Default value of sub-table to foreign key
Posted: 2013-08-17 09:42
If People is the main table and each person can have many Dogs. They are linked with the PeopleID Primary Key from the People table and the PeopleID in the Dogs table one to many. When in the People table and you want to add a new Dog, is it possible to make the PeopleID in the Dogs table default the PeopleID from the originating People deatil view where we clicked on Dogs? That way the IDs of both tables can be hidden from users but will automatically have the right Dogs linked to the right People?