Having problems with a table relation
I sell tours and transfers all over the world. I have a database that allows me to select tours and transfers for my clients two different layouts. I produce vouchers based on the information entered. When selecting a transfer on a booking we are to enter an airport and when the voucher comes out it indicates the airport selected on the voucher. This works just fine
On the tour side of things for the most part tours do not involve transfers therefore an airport selection is not necessary, however sometimes we have what we call a transfer tour. Which may involve picking up the client at the airport doing a tour and then ending services at the pier or hotel. Here is where we have a problem even though they layout displays the correct airport for data entering, the voucher is coming out with another airport not the one we chose, or the field is blank.– I have attached a clone copy of the database for easier picture if anyone is interested I can email it – Can you help
Uploading a screen shot of the relevant portion of Manage | Database | Relationships might help. Then identify which box on the graph corresponds with the layout where you are having this issue.