Dear All,

I would greatly appreciate if you can support me in enrity relationship issue.

The is a one-to-many relationship between EntityA (PK:GUID) and EntityB (PK:GUID, FK: EntityAGUID) . Example, one "Entity" can have multiple "Portfolios". However, i have three types of type Entitiey A which need to be in seperate tables because each has it's own properties. Example,
EntityA can be a Client, a Company, or a Fund

Client Company Fund
| | |
| | |
|_______ Portfolio _____|

I am looking to have the same PK for the three tables "Client / Company / Fund " so that there will be no conflict in the "Portfolio" FK.

Please advise for the best ERD structure.
Greatly appreciated

entitysupertype --- 1-m --- portfolio
| | |
| | +-- 1-1 --- clientsubtype
| +-- 1-1 --- companysubtype
+-- 1-1 --- fundsubtype

Thanks for your reply, it is what i am looking for

Hi Mr Aloha,
Listen....you're mixing Apples and Oranges as we say in the data modeling word.

If you're telling me A Client, A Comany and a Fund are three of the same type of thing, you didn't watch Sesame Street growing up.

Looooook - A 'party' is a person or organization
A fund is an account to group holdings or transactions under

I smell something fishy here....

Vmuisc