Forum Discussion
struggling to grasp the concept...
Hi, i am attempting an access DB for a dog rescue. i have a table for people, one for dogs and one for status' (i.e. been surrendered, been fostered, been adopted). in my dog table i have FK fo...
thanks. so i currently use a form to add people and another to add dogs. i take it that i would then need another entry form to add the link between the person and the dog and the dog's status?
i'm trying to make data entry as simple as possible as the people likely to use the DB are not the most computer literate. 🙂
thanks again,
g
It is usual to use a subform in such a case. You can choose to create a status subform for the dogs form. Fill in the status and the person on the subform. It is also possible to create a subform for person. The dog approach seems the most logical to me.
- my apologies for all the questions...
as the dog form is a data entry form (the dog is not in the DB yet) how would i go about adding the dog to the DB as well as it's status and the person responsible for the dog? would i need to do that as two distinct forms and actions, so add the dog and then open another form to add the status and person?
regards,
gIf you enter a new dog on the form for the dog, you can immediately enter the first status on the subform. If the person is also new, it is better to enter this in advance. Then you can immediately choose the person when entering the status.
I've put together a very simple sample database to demonstrate those principles. See attached file.
- thanks again... i must owe you!!!
i'm having problems with the subform, if i run it by itself i get the dropdowns with the status options and the list of people in the DB, however when i drop the subform onto the addDog form i don't get those???
g
- thanks. appreciate your time.
g