Restructure lots of fields




I have a collection of qualitative information on a large number of
investment funds. For each fund there is a manager (lots of related details);
dealing terms (lots of related details); firm (lots of related details) etc

My fund table has the following fields

I then had a manager table, dealing terms table etc where those records were
linked to the fund via the FundID to the 'main' fund table. This has resulted
in 5 tables with a one-to-one relationship with the fund table which I'm not
conviced is a good structure . . .

What I have is similar to a survey - lots of people have referenced Duane
Hookom's survey database, but the link in previous posts doesn't seem to work.

Please could someone point me towards an appropriate example or give me some
restructuring ideas.

Many thanks

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question