question about relating tables and end reports

[aussie_user]

HI,

I've just been asked to add some information to a database I have partially built and would appreciate some suggestions on how I should go about it.

Currently for exisiting projects I have a table that contains fields for up to 12 payments, for each of those payments I also have a related date paid field and GST amount field. These 36 fields combined with a few calculation fields (eg refunds, total paid to date etc) makes for a rather large query.

I now have to find a way to add 2 more fields associated with each of those 12 payments (progress report due date and payment due date).

My question is should I put the 24 fields that I have to add in a separate table (called Schedule) rather than add them to the exisiting table?

I want to be able to eventually produce a report that will show all of the information in such a way that I can show the 5 fields related to each payment are shown on one line.

Thanks

 

[Rich]

It sounds as though you need to normalise your db, search here for posts on the subject