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
Post a Comment