General discussion

Locked

SYNCHRONIZED FORMS

By raffyplacido ·
Hello Everyone,
I am a beginner in Access Database. I've created a database using a Main Form and a subform. The results are okey, I have them (data on main form & subform)pushed on a local table up to the point where the main data are kept, however I still have some concerns: Would it be possible to link two tables without using a subform? How? Please advice. Do I make use of VBA? How do i start? What are the steps that I have to follow? Please comment.
Thanks a lot
Raffy

This conversation is currently closed to new comments.

10 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

SYNCHRONIZED FORMS

by raffyplacido In reply to SYNCHRONIZED FORMS

Point value changed by question poster.

Collapse -

SYNCHRONIZED FORMS

by mrdbcooper In reply to SYNCHRONIZED FORMS

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.

Collapse -

SYNCHRONIZED FORMS

by raffyplacido In reply to SYNCHRONIZED FORMS

The question was auto-closed by TechRepublic

Collapse -

SYNCHRONIZED FORMS

by donq In reply to SYNCHRONIZED FORMS

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!

Collapse -

SYNCHRONIZED FORMS

by raffyplacido In reply to SYNCHRONIZED FORMS

Hello,
As a beginner in database developing, I'm having some problems on the terns that were given by the person answering the question.
I'm a little bit confuse regarding data modelling, was it the same with the normalization ...the boyce-codd normal form.
Thanks for your help.
Raffy

Collapse -

SYNCHRONIZED FORMS

by robbinsr In reply to SYNCHRONIZED FORMS

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.

Collapse -

SYNCHRONIZED FORMS

by raffyplacido In reply to SYNCHRONIZED FORMS

The question was auto-closed by TechRepublic

Collapse -

SYNCHRONIZED FORMS

by James_Randy In reply to SYNCHRONIZED FORMS

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

Collapse -

SYNCHRONIZED FORMS

by raffyplacido In reply to SYNCHRONIZED FORMS

The question was auto-closed by TechRepublic

Collapse -

SYNCHRONIZED FORMS

by raffyplacido In reply to SYNCHRONIZED FORMS

This question was auto closed due to inactivity

Back to Windows Forum
10 total posts (Page 1 of 1)  

Related Discussions

Related Forums