I am constructing a database for a small museum. I've got two main forms - one for entering a donor of an artifact collection's name and one for entering detailed information about each artifact in a collection.
The donor form has input for the donor's name, address and phone number and has a subform where many artifacts can be attributed to a single donor.
The object data entry form allows the user to input detailed data about each artifact to enable them to be found and sorted easily later on. When dealing with thousands of artifacts, it becomes really handy to have a combo box that a user can look for the object's unique accession number and automatically find that record.
I tried adding a lookup combo box, but whenever I select the field or any field for that matter to look up a record I get this error:
"Data cannot be retrieved from the source you have selected. You must select a different table or query to continue in the wizard."
What does this error really mean and is there some way I can fix it?
The donor form has input for the donor's name, address and phone number and has a subform where many artifacts can be attributed to a single donor.
The object data entry form allows the user to input detailed data about each artifact to enable them to be found and sorted easily later on. When dealing with thousands of artifacts, it becomes really handy to have a combo box that a user can look for the object's unique accession number and automatically find that record.
I tried adding a lookup combo box, but whenever I select the field or any field for that matter to look up a record I get this error:
"Data cannot be retrieved from the source you have selected. You must select a different table or query to continue in the wizard."
What does this error really mean and is there some way I can fix it?