I have a DB for my mouse colony. Each entry has the mouse tag, room location (there are 2 rooms) and cage location within each room. Each cage can host up to 5 mice. However, cage location overlap and need the room number to be identified.
I am trying to link/lookup the main table to another table in which each record represents a cage location and has the following fields:
-number of mice in room 1
-list of tags of mice in room 1
-number of mice in room 2
-list of tags of mice in room 2
I started by linking the cage location but when I add a field to lookup back from the main table to list the tags filtered by room location, I get no results… Any advice?