AnsweredAssumed Answered

Unrelated table

Question asked by db49er on Feb 14, 2014
Latest reply on Feb 15, 2014 by db49er


Unrelated table


     I have three tables:

     Aircraft:            Registration, Type etc.

     Flight:               Date, Time etc.

     Passengers:    Name, Address etc.

     I have related Aircraft and Flight and everything populates as desired on a layout.  I now need to select some passengers from their table and add them to the flight, keep a permanent record of that flight and forward it (probably as PDF) to a third party.  I have tried relating Passengers to Flight with the x operand and performing a find in a portal, adding another table to store the collective fact I have tried all sorts of ideas but to no avail.  I know that it does not sound very complicated but I have hit a brick-wall and would appreciate any suggestions.

     Thank you