I have built a form for entering offspring into a database for a laboratory that breeds mice. I know very little about access however, trying to learn as I go along, but I need help with setting up how this form updates or adds records to the various tables associated with it.
I'm trying to use a subform to select the parents of the offspring from a query. So my question is, how do I pull the MouseID records from the parent cage selected and use them to associate the offspring with their parents in a MiceRelations table. Here is what the form looks like to give you a better idea:
![]()