I know it's been only 3 days since FM intermediate training, but I can't get this to work. A have a layout for inspections of orchards. 'Inspections' are a child table of the parent table 'Orchards' (many-to-one). My layout has the child table fields and when I have entered the inspection record I then type in the foreign key which matches with the parent record primary key in which the inspection took place (i.e. identifies the correct orchard).
That works fine.
But I have a poor memory and so I need a drop-down list of Orchard Names et al so that I can enter the correct value into the foreign key field to fetch the correct Orchard record.
How can I do this? - i.e., basically have a display list of all parent records on the child entry layout so the user can make the proper connection between parent and child. (either manually or automatically)