Normalizing Database and Form Control

[PurpleGod]

Hi I'm trying to figure out how to normalize my database, I read tutorials on Normalizing but I can't seem to make it work. My current database is functional but not practical. Because It was not normalized I ran into the problem for having over 255 fields... Here's what my database consists of:



Investors
Funds
Payments

Each Investor has contact information
Each Investor is part of many funds
Each Fund has many payments
Each payment consists of a date and a number

For example:

Person1 could be in Fund1 and Fund2, They have made payments for both funds (Payment1Fund1,Payment2Fund1 and Payment1Fund2,Payment2Fund2)

How should this database be normalized?
Also, I want a form that can display each investor, which funds they are in, and they're payments for each fund.

Currently I'm using the Tab Control, and I have a tab for each fund which I love! How can I keep this format?

[ranman256]

tables design:

tInvestor. details about investor only. Name, addr, phone. (no payments, just person info)
[InvID] key field autonum

tFunds
[FundID] autonum
[InvID] long integer (key from tInvestor)
[fundName]
...more details about the 1 fund

tFundPayments
[FundPayID] auto
[FundID] long (key from tFunds)
[paydate]
[Amt]
...etc

[orange]

It is quite rare to have a relational database with a table approaching 50-60 fields.
I recommend you review and work through 1 or more of these tutorials from RogersAccessLibrary.

http://www.rogersaccesslibrary.com/T...lationship.zip
http://www.rogersaccesslibrary.com/T...erItDesign.zip
http://www.rogersaccesslibrary.com/T...cripDesign.zip

You have to work through them, but you will learn the concepts of database design, tables and relationships.
Any everything you learn can be used when developing any database.

What exactly is the business you are trying to support. You really need a clear and complete description of the business and processes you are trying to support with your proposed database. And you need to know that before you get too deeply involved with Access.

For additional info see links in this post.
Good luck.

[PurpleGod]

Ranman, I used your template, but when i created a form with the data, i get at error "Cannot create record, field not in recordset"