Rynman
02-01-2007, 09:08 PM
Hey guys
Access rookie here (and I mean ROOKIE).
I have two tables.
One with details of people's information (mothers).
We also need to enter information for their babies.
Basically I have set up a form with the info for the mother's details, and she has a Mother ID. The baby also has an ID which should be the same as the mothers (linking the two tables).
When I enter the info into the form for the mothers details, I hit the command button that opens the baby's details, however it has not created a baby ID that is the same as the mother's ID, therefore there is no relationship. If I enter in the baby id, and fill out the form - I goto the table and see that it has made the link and the information is complete. However, I don't want to have to enter the ID each time.....I just want the mother's ID to carry accross to the baby's ID field, hence linking the two.
Why isn't this working?
Thanks for your help!
Ryn
Access rookie here (and I mean ROOKIE).
I have two tables.
One with details of people's information (mothers).
We also need to enter information for their babies.
Basically I have set up a form with the info for the mother's details, and she has a Mother ID. The baby also has an ID which should be the same as the mothers (linking the two tables).
When I enter the info into the form for the mothers details, I hit the command button that opens the baby's details, however it has not created a baby ID that is the same as the mother's ID, therefore there is no relationship. If I enter in the baby id, and fill out the form - I goto the table and see that it has made the link and the information is complete. However, I don't want to have to enter the ID each time.....I just want the mother's ID to carry accross to the baby's ID field, hence linking the two.
Why isn't this working?
Thanks for your help!
Ryn