T
Thorson
I currently have a table set up ('tblBirthInformation'), when an animal is
born the Dam (mother) and Sire (father) are put in the table. The sire field
currently has a combo box, but I would like to limit the options in that box
based on other tables in the database. Two other tables
('tblArtificialInsemination' and 'tblCleanUpBulls') List possible sires for
the calf depending on the Dam.
I would like it so that when the user enters the Dam's EarTag
(identification) into the table the combo box in the Sire field will look up
the possible Sires based on the tables 'tblArtificialInsemination' and
'tblCleanUpBulls'.
How do I do this? Let me know if you need clarification.
born the Dam (mother) and Sire (father) are put in the table. The sire field
currently has a combo box, but I would like to limit the options in that box
based on other tables in the database. Two other tables
('tblArtificialInsemination' and 'tblCleanUpBulls') List possible sires for
the calf depending on the Dam.
I would like it so that when the user enters the Dam's EarTag
(identification) into the table the combo box in the Sire field will look up
the possible Sires based on the tables 'tblArtificialInsemination' and
'tblCleanUpBulls'.
How do I do this? Let me know if you need clarification.