T
Thorson
I currently have two tables:
#1: tblBirthInformation
#2: tblPurchase/Donations
As animals die or are sold or transferred they recieve a disposition number
which is entered into another table. I then have a query set up that
displays the animal's birth date, current location, breed code etc. Each
indivdual animal ID is pulled from the tblBirthInformation table. I would
like it to pull in additional animals from the tblPurchase/Donations table
and treat the fields exactly the same as it treats the tblBrithInformation
table. They will have some of the same fields with different records, (also
many different fields that will not be used in the query).
Is this possible? How would I set up the relationships in the query?
My other option would be to copy partial records from the
tblPurchase/Donation table after update to the tblBirthInformation table, but
this would create duplicate information on the same animal.
#1: tblBirthInformation
#2: tblPurchase/Donations
As animals die or are sold or transferred they recieve a disposition number
which is entered into another table. I then have a query set up that
displays the animal's birth date, current location, breed code etc. Each
indivdual animal ID is pulled from the tblBirthInformation table. I would
like it to pull in additional animals from the tblPurchase/Donations table
and treat the fields exactly the same as it treats the tblBrithInformation
table. They will have some of the same fields with different records, (also
many different fields that will not be used in the query).
Is this possible? How would I set up the relationships in the query?
My other option would be to copy partial records from the
tblPurchase/Donation table after update to the tblBirthInformation table, but
this would create duplicate information on the same animal.