Three tables on one form

P

PawelR

Hello group,

I beginner in Acces and my problem is propabillty very easy.
In my database I have three table:

TabA (idTabA[PK] , FieldA1, FieldA2, FieldA3)
TabB(idTabB[PK], idTabA[FK], idTabC[FK], FieldB1, FieldB2)
TabC(idTabC[PK], FieldC1, FieldC2)

I need all tables in one form and if I chose record froma TabA table "B"
show records with TabA.idTabA = TabB.idTabA and if chose record in TabB tabC
show me records with TabB.idTabC = TabC.idTabC. This must work silimary to
TreeView.

I want make this without Access Wizard (manual)

Thx PawelR
 
R

Rick Brandt

PawelR said:
Hello group,

I beginner in Acces and my problem is propabillty very easy.
In my database I have three table:

TabA (idTabA[PK] , FieldA1, FieldA2, FieldA3)
TabB(idTabB[PK], idTabA[FK], idTabC[FK], FieldB1, FieldB2)
TabC(idTabC[PK], FieldC1, FieldC2)

I need all tables in one form and if I chose record froma TabA table "B"
show records with TabA.idTabA = TabB.idTabA and if chose record in TabB tabC
show me records with TabB.idTabC = TabC.idTabC. This must work silimary to
TreeView.

I want make this without Access Wizard (manual)
Click to expand...

Tabs cannot point to separate RecordSources. They are merely a tool for
organizing the layout of controls on your form. You can however use
subforms on the TabControl pages and get the desired outcome.
 
Top