SYNCHRONIZED FORMS

Point value changed by question poster.

Yes there is a way to create forms that tie information from two or more tables together without using the sub-form process.
The first is an older style of Access form building using Linked Forms.
The Quickest (But not always the most user friendly) way is to do the following:
Select your Forms Tab and click on New
Select the Form Wizard (do not specify a table yet!)
When the Wizard Dialog Box loads Select the
main Table and highlight all the fields you want for the form.
Then Select theother Table and highlight all the fields you want from it.
MAKE SURE THAT BOTH TABLES HAVE A UNIQUE RELATIONSHIP BETWEEN THEM (e.g. a unique ID# or other field)
Click on Next
Select Linked forms instead of form with subform(s)
Click through the nexts until the Wizard completes your forms.
The Forms will be linked via your unique ID.
The other way is one I cannot recommend without warning that you must be EXTREMELY carefule in editing and/or deleteing information from the form. It is probably best if this style of form is left as a 'Read-Only' form for quick look-ups.
Create a query that has the main table fields
you need and the other fields from other tables. (Make sure that you ONLY bring in the UniqueID from the Main table and none of the others, also make sure your tables are linked by that ID)
Save the query
Now select the forms tab
And select New
Build a Column Form with the Wizard
Select the Query you made and let the wizard
build that form.
Make sure you go intothe design of that form and make all the fields read only by
setting the properties to Enabled: NO
Now that form has all the information in a column view without the subforms.

Hope this helps.

What you need is called Data Modeling. There are a few simple rules stating 1: Each Table should contain iinformation about ONLY one subjecct. 2: Each Column within a Table should contain ONLY one Face or value related to the table's subject and have a UNIQUE COLUMN NAME. 3: One column in each Table MUST contain a UNIQUE value so individual records can be found (it is often called the Primery Key).

Relationships are established between different Tables then table "B" contains a Column that stores the Primary Key value from Table "A". That column in Table B is called the Foreign Key and it establishes a relationship between Tables "A" and "B".

Another way is to build a single query using both Tables as the query data source and using "drag and drop" to establish an undefined relationship. To do this the above relationship fields MUST EXIST so you can grab the correct field to "drag" somewhere.

This stuff is KEY to becoming a guru in ANY database. Good luck and just checkout Key values in your manuals!

Has your question been answered? If so please close your forum, if your question is still open please repost it with more current information. Thank you.

Since you rejected all those answers, why don't you just close your question? Never mind, I'll do it for you.

This question was auto closed due to inactivity