How to create a form

[bra1niac]

Ok, I'm new using Access... sort of. I have been maintaining data for a while, but not adding functionality, etc. I am also a bit undecided whether I want to use access exclusively or use the db with a vb app (which would be easier for me, but I'm not one to back down) that wouldn't take long to write.

I'll keep it simple. 3 tables, one linked to the next:

tblOne
------
IDOne - one exclusive parent
[Data]

tblTwo
------
IDOne - one to many
IDTwo
[Data]

tblThree
--------
IDTwo - one to many
IDThree
[Data]

How can I make a form that will allow me to update the parent and then the as many records for the other two tables as needed while maintaining their relationship to the parent. Every attempt I have made enters nothing into the tables.

Thanks in advance. "It's easier to ask forgiveness than it is to get permission." - Rear Admiral Dr. Grace Hopper

 

[JoeMiller]

Did you define the relationships in the relationships window? When you added your subforms did you check that the Child and Parent field properties were setup correctly?

Access will automatically start doing this if you first define the properties, make the main form, make the subform and then add the subform to the main form. During the wizard it will ask you how to relate (it should know if you've set the relationships up properly) and will then start working as you suggest automatically.

HTH Joe Miller
joe.miller@flotech.net