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 data......in 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.