Simple Relational Database

[Knawl]

Hi,

Shamefully, I am struggling to understand relational databases. I can't put my finger on it.

What I need to is to have one table containing a number of persons that are related to one record on my main table. And those to be displayed on a subform.

I've attached the current excel format of the data. This issue is there could be any number of clients or agents which is why I want a subform visible in the main form.

I've also put an example of the desired form format on sheet 2.

Any help would be greatly appreciated.

 

[zoran.eremija]

Based on the above I suggest you the following model.

 

[Knawl]

Hi,

Please see attached. This makes no sense to me at all.

 

[jdraw]

In your database, RoleId should NOT be the PK of ProjectPerson table. It should be simply a long Integer field (FK) to RoleID in Role table.
PK of ProjectPerson table is a composite PK made up of ProjectId and PersonID -- as shown in diagram by Zoran.

 

[zoran.eremija]

Your model is not good. The model that I have proposed is made in the IDEF1X methodology. See attached properly.