where buttons take you

[Guest]

I have forms attached to one main form. What I want to do is make the
records match, i.e. if on record one of the main form, the button takes me to
record one of the attached form and so on. I know it must simple I;m just
not sure of how to do it. Please help. Oh, one more question, if I make
lets say 5 tables, create a form for each and then attach them to the main
form, will they automatically create their own relationships?

 

[Rick B]

The button wizard will offer you the option to open the new form and open it
to the record selected in your main form. Have you tried addin the button
using the wizard and selecting the option, "Open the form and findspecific
data to display." It will let you find the matching fields in your main
form and the new form.

 

[Guest]

You need to create relationships. For the rest, you will need to describe
what you need the database to do. What is its purpose? Saying that you have
attached a form to another form is not much to go on.