This shouldn't be so difficult to explain so here goes.....
I have a Parent Table with 2 child tables:
ITEMS - Parent
CHILD - Current Inventory
CHILD - Inventory Inspections
I need to be on the current inventory table and create a button to complete an inventory inspection for the common parent.
How can I do that? I've searched all over and everything seems to be suggesting creating a relationship between the two children and I DO NOT want to do that. My current inventory records will be purged nightly so the relationship has to be with the parent. Any help is appreciated.