This is a different topic than the other "from based on a query" problem. Here is the skeleton of the database:
tblInstruments one to many with
tblLink many to one with
tblCustomers
So the link table has two primary keys (and only two fields, for that matter) which is allowing me to assign the same instrument to multiple customers, and assign multiple customers to a single instrument, but yet retain the uniqueness of both customers and instruments.
And let me tell you, the data structure is completely correct. If I work with the database as it exists everything works for data entry.
The problem is this. I have the following two queries:
qInstrumentsToCustomers which is based off of the tblLink and tblCustomer; and,
qCustomersToInstruments which is based off of the tblLink and tblInstruments
allowing me two different views of the same information. I hope this is clear!
Here comes the problem. Those two queries have all the right information in them. Not a single problem. But I have now made a form based on these queries, and none of the information shows up in the form! Worse yet, I can still add information to the underlying tables, but this information (if I switch views or records) promptly disappears from view. It is still there in the underlying data, but it won't display in the form even though it displays in the query.
What is going on here? Does anyone know?
tblInstruments one to many with
tblLink many to one with
tblCustomers
So the link table has two primary keys (and only two fields, for that matter) which is allowing me to assign the same instrument to multiple customers, and assign multiple customers to a single instrument, but yet retain the uniqueness of both customers and instruments.
And let me tell you, the data structure is completely correct. If I work with the database as it exists everything works for data entry.
The problem is this. I have the following two queries:
qInstrumentsToCustomers which is based off of the tblLink and tblCustomer; and,
qCustomersToInstruments which is based off of the tblLink and tblInstruments
allowing me two different views of the same information. I hope this is clear!
Here comes the problem. Those two queries have all the right information in them. Not a single problem. But I have now made a form based on these queries, and none of the information shows up in the form! Worse yet, I can still add information to the underlying tables, but this information (if I switch views or records) promptly disappears from view. It is still there in the underlying data, but it won't display in the form even though it displays in the query.
What is going on here? Does anyone know?