Problem with relationship subforms in access 2010

[fekrinejat]

here is the situation :



There are three Tables (Person , Education , Relative)
There is Person_No field in all of them which is (PK) in Person Table
and (FK) in two others .. so there is a One-to-many relationship
between (Person - Education) and (Person - Relative)

Now if i create a Form based on Person , i can't see
two other tables (Education , Relative) as subform in a Tab (a view) ..

any idea about fixing this problem
Thanks

[June7]

I don't understand the issue. Why can't you see the other tables in subforms on Tab control?

[fekrinejat]

Actually When i click on Person Table from Tables List and select "Form" from "Create" Tab
i expect to show me Person records list on top and two subform (Education , Relative) in below,
but i can just see Person Record ..

When i open Person Table , there is + sign and when i click on it a window contains tables
will apprear which i have to select one of tables due to show related record in that table..

sorry about my bad explanation

[June7]

Does this help http://office.microsoft.com/en-us/ac...010098674.aspx

[fekrinejat]

It didn't help .. i know how to use Form and SubForm in Parent/Child structure
it works when my relationship is like:

A---> B---> C

But my situation is like :

A ----> B
A ----> C
A ----> D
A ----> E

on just one unique field shared between tables .. Access tells me you have to
choose one of your relationship due to view in Form/SubForm..

I need A on Top and four SubForms in one page in down which is related to A


any idea ?

[June7]

The first example looks look a form/subform/subsubform arrangement.

Don't understand why the second example is an issue. Should be able to have multiple subforms linked to the same parent main form.

If you want to provide db for analysis, follow instructions at bottom of my post.

[fekrinejat]

That was my stupid mistake , it fixed .. thank you