Changing relationship

[Guest]

Hi

I have a simply DB that catches qualitative information about investment
funds. My 'master' table has the following fields:

FundID (autonumber)
ManagerID
HouseID
Fund Name

For each fund, users can input the details of the manager and the investment
house which works well. I have now had a request to input funds that a
particular manager was associated with historically.

My current relationship is one manager per fund. Now I need to be able to
capture several 'old' funds per manager. Any suggestions on a neat way of
capturing this data without messes with my existing structure?

Thanks,
Tarryn

 

[Jeff Boyce]

Tarryn

I don't know about your "domain", but in my world, one manager could manage
several funds, and one fund could be managed by multiple managers. For me,
this is a many-to-many relationship, requiring three tables:

tblManager
ManagerID
(who)
....

tblFund
FundID
(which fund)
.....

trelFundManager
FundID
ManagerID
StartDate
EndDate

This design allows for a "history", and requires one row per valid Fund X
Manager combination.

Good luck

Jeff Boyce
Microsoft Office/Access MVP