How can I get automatic (or programmatic) completion of the foreign
key field when inserting a detail row if the field name is different
to the master key field name?

I've been fiddling with the datasource property of the query but I
think it only works if the field names are the same.

I'm finding this impossible to figure out. Any sample code would be
very helpful.

Many thanks

Mitch