Hi all,
I have a table for…
- Company (contains company name, address, phone etc.) Primary key is “Corp ID”
- Company Contact (because a single company can have several contacts) containing a person’s info and a Contact ID and a Corp ID (update & delete cascade).
- Reservation Info (date, time, etc) and a Contact ID linked to the upper table
- Theme Package (a food package for children) with a link to the Reservation ID
- Adult Package (a food package for adults) with a link to the Reservation ID
Now, we take reservations for groups that do not take either food package (a la carte) so at this point there aren’t any entries on the Theme package table or Adult Package Table. When I create a query to display all the above info my query returns zero results. If I remove the last two tables from my query I get the names, phone #s, reservation date and times.
How can I get my query to show results if my last 2 tables do not have any contents?
Thank You