Hi, I am designing a database for a small museum with the purpose of cataloguing all of the artifacts in the museum using hard-copy records. I've got two main forms to enter the data - one form to enter a donor, their name, address and phone number and another to enter all of the information for the artifacts that each donor has donated. The donor form has a subform on it that displays all of the artifacts donated by that specific person, but it is not ergonomically useful to use it to enter artifact data. Now the problem.
I want to have the donor name, address AND phone number show up in the artifact data entry form, but as it stands, only the donor name shows up thanks to the relationship between the donor name field in both forms. I tried to create relationships for the other two fields, but that has proven fruitless. IS there a way to get the field to look up the value (whether it be the phone number or the address) in the other table using an expression in the control source field? I don't have any idea on the syntax or how I would go about it.
Thanks a lot.
Bachfile
I want to have the donor name, address AND phone number show up in the artifact data entry form, but as it stands, only the donor name shows up thanks to the relationship between the donor name field in both forms. I tried to create relationships for the other two fields, but that has proven fruitless. IS there a way to get the field to look up the value (whether it be the phone number or the address) in the other table using an expression in the control source field? I don't have any idea on the syntax or how I would go about it.
Thanks a lot.
Bachfile