I've tried this before myself. It will allow me to create the relationship, no problem. However, If I try to run a query that includes airline, It will respond with zero records. I need to be able to run queries to 'see' the airline based on the PurchaserID, OperatorID, or both.
I have a situation were I have a main table and several additional tables that have relationships based on an ID using an auto-number. Anywhere I have a word followed by ID is a place where a relatiohship exists between two tables using an auto-number.
I have one particular table (tblAirline)...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.