database - Updating a link table using Access form/SubForm -


i have database has following structure:

pet(pet id, name, type, dob, allergies, etc)

owner(owner id, forename, surname, dob, address, etc)

registered(reg_id, pet_id, owner_id)

the reason structure being remove many many relation whereby pet may have several owners, aim several people responsible animal in question.

my aim have 1 form allows me set 1 owner , pets @ same time (owner pet sub-form), pet should automatically added registration table @ point owner.

other owners added through registration table itself.

any suggestions on how in access? i'm trying avoid stating pets can have single owner.

thanks


Comments

Popular posts from this blog

account - Script error login visual studio DefaultLogin_PCore.js -

xcode - CocoaPod Storyboard error: -