Too many Indexes Error Message

[Bigmo2u]

I am a beginner when it comes to access. The project that I am working on is tracking Travel claims. The claims are submitted ever month for 4 years so I have created 48 tables for each month and tried to link them via the SSN. The member can also submit other claims during this period, ie supplementals (for reimbursements that were missed in the monthly) and Concurrent duty claims (for the member going to additional sites then where they are assign).

I have a

MBR tbl - that holds all the MBR's info (SSN, name, unit, city, state, POC, POC email and Remarks)

(48) Partial tbl - linked by the SSN.

(5) Suppplemental tbl - Linked by the SSN ( I need more of these but I started with 5)

(5) Concurrent tbl - linked by the SSN ( I will need more of these)

These are all one-one relationship.

How can I get this to work. I can upload a blank copy of this database.

Thanks for any help
Craig

 

[KenHigg]

"48 tables for each month " = I would suggest you read up on normalization.

 

[Bigmo2u]

48 tables = 1 table per month for 4 years.