Help with form creation with 2 or 3 tables

sorebrain

Registered User.
Local time
Today, 08:31
Joined
Oct 8, 2004
Messages
27
I started this post in the General area but it I believe it needs to be here now that the subject is about forms. I need to know the correct way to make a form that has fields from 2 or more tables that a user could enter the complete record using only 1 navigation control. I believe I figured out that I need to create a "sub-form" and then add that sub-form to another form that has the primary table. Is this correct?
Thanks,
sorebrain

Access 2000
learning as fast as I can :)
 
Before you start building your forms, make sure that the relationships between your tables are properly defined. Also note the suggestion I made for a change to your table design.

When you build a form with a subform, it is fine to remove the navigation controls from the main form. You can add a combo that lets you select a customer so there will be no need to navigate. For convenience, you might want to add your own add and delete buttons though.

If the relationships are properly defined, Access can make educated guesses as to how things should link together and when you add the subform, it will usually pick out the correct master/child fields but make sure.
 
Ok, I am back in the General area

Thanks Pat. I am back in the General area to get my original questions off to a good conclusion. I have been hard at it but even though only 5 days went by, I have been writing the date as 2 days ahead of today :D So I guess I have 7 days experience :cool:
sorebrain
 

Users who are viewing this thread

Back
Top Bottom