Creating a Form bounded to three tables with one-to-one relationship

  • Thread starter Thread starter Rony Boter via AccessMonster.com
  • Start date Start date
R

Rony Boter via AccessMonster.com

Hello,

I'm quite new with the creating Form in Access;

I was trying to create a Form, which is bounded to three tables, which
have one-to-one relationships.


I have the following database design which is based on what so called ?Polymorphism? the inheritance is as fallows:

tblPossition is in the 1st level
tblManagers is in the 2nd level
tblDitrictManagers and tblTechnicalMangers is in the 3rd level:



The tables are as fallows:


tblPosition
ID [PK] Autonumber
AttributesCommonToAllPositions

tblManagers
ID [PK], one-to-one relationship with tblPosition
AttributesCommonToAllManagers

tblDitrictManagers
ID [PK], related with one-to-one to tblManagers
AttributesOfDistrictManagers

tblTechnicalMangers
ID [PK], related with one-to-one to tblManagers
AttributesOfTechnicalManagers

I have tried to make this Form, which bounded to a query (tblPosition inner join on ID tblManagers) inner join on ID tblDitrictManagers.
But I get this message that I can't add or change a related data for tblPssition.

How can I bind a Form to Three tables with a relationship of one-to-one?


Many thanks in advance
Rony Boter
 
Hi, Rony.

Create forms to display the tblManagers, tblDistrictManagers, and
tblTechnicalManagers data, and insert them as subforms onto a main form based
on Positions. You needn't and shouldn't include a control bound to the
foreign key on any of your subforms.

For each subform, set its LinkMasterField and LinkChildField properties to
the tblPosition PK and the foreign key fields, respectively.

Hope that helps.
Sprinks
 
Back
Top