linking subforms

[rasticle]

I will try to explain this the best I can. I am attempting to make a user interface for access using pages. This is new to me. So this is what I have done so far. I have 1 main form. On the main for I have the tabs set up with subforms in each of them. What I am trying to do is link all of the subforms to the first subform using the first subforms primary key. Is this possible? Here is a list of what I have so maybe it will make this easier to articulate...
-1 main form,

-inside the main form I have one of those page things set up with 5 tabs.

-inside each tab there is a subform that corrolates with a table.

-the first tab has the subform for facility. It has a primary key of the ID number for each facility.

-the subsequent forms have details about the facility.

-I would like for the subforms to be able to pull up information related to the facility on a one-to-many relationship. Meaning 1 ID number for multiple occurences of details about the facility.

If anyone understands my rambling and can help I would be greatful. Thanks!

 

[Remou]

Have a look at the Orders form in the Northwind sample database? Is it what you visualize, except with tabs?

 

[mhartman1]

Hello:

You need to first set your table relationships between your two tables. Then base a query on these tables and use that query as your record source for your form.

Regards
Mark

 

[rasticle]

The tables are already related. So far whats happening is that one of the detail forms is seing the ID number, but it is always reading the first ID number in the table, and not the ID number that is displayed on the "main" subform. So it is kind of linked, but its not pulling the correct ID number.

 

[rasticle]

Where can I find that sample database? I can't seem to find it.

 

[Remou]

You will get all the details here:

http://office.microsoft.com/en-us/access/HA010546951033.aspx

The default location is:

Program Files\Microsoft Office\Office\Samples

 

[rasticle]

Yes somewhat similar. I would like the first tab to work like the "main" form, where you can enter a Facility's information including its ID number. Then on the subsequent forms, with Facility information, be able to display information by pulling the ID number from the main form. I have done this before, but using normal forms, I don't know what I am doing wrong on this.

I have the master and child field links set up correctly. But for some reason the child forms showing the wrong Facility ID number. They are showing the ID number that is first on the table, I have never encountered this before.

 

[Remou]

Sorry, I gave you the wrong reference. Have a look at the Customer Orders form. You will find it has two related subforms.