Tabbed Form Help

[Jen_RT]

I am using Access 2003 and am relatively new to access.

I have 4 main tables in my database, tables 1, 2A, 2B1 & 2B2.

The user can enter information via tables "1", "2A" or "1", "2B1", "2B2" depending on how they respond to a question in table 1.

I have set up 15 forms as the tables contain many fileds. (thus the reason for tables 2B1 and 2B2)

For example: table 1 has been split into forms A, B, C & D (all linked via a primary field).

All of the forms are currently on a tabbed form with tabs (A to O).

My problem is that I dont know how do I link the forms to one another. I have put the primary key into each of the subforms, but this wont allow me to proceed to form B with the same primary key as it would try to produce a duplicate key (which is not enabled).

Any help would be greatly appreciated.

 

[KenHigg]

I'm not sure this would work but you can set the data source for a main form to your large table and spread the fields out over multiple tabs and not have to deal with sub forms at all...

???

 

[Access_guy49]

What is your relationship structure?

e.g.
Table 1 is a one to one relationship with table 2A

Or is it a 1 to many?
or Many to many?

posting a screen shot of your relationship might be helpful. To me it sounds more like a relationship problem and less like a form/subform problem.

 

[Jen_RT]

I cant print a screen shot because of client confidentiality, sorry.

Table 1: has a primary key, say "p1". Within table 1, there is a foreign key "p2" and "p3", depending on which way the user wants to proceed.
Table 2A: has a primary key say "p2".
Table 2B1: has a primary key say "p3". Within table 2B1, there is a foriegn key "p4".
Table 2B2: has a priamry key say "p4".

All of the relationships are 1:1. The reason for the table 2B1 and 2B2 are that because there are so many fields, they could not fit in one table.

Hope this is relatively clear. Thanks