AnsweredAssumed Answered

display multiple parent records?

Question asked by lombardi3g on Jul 22, 2015
Latest reply on Jul 23, 2015 by lombardi3g

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)


TIA,  Allan