>My current data design scheme has three tables (Funding, Payments, Charges) to handle financial data of different types. Each has a primary key, two foreign keys, date, amount and an additional field or three.
>
>I was going to make a change to all three tables when the obvious question hit me: Would I be better served to collapse all three into a single table?
>
>Any opinions to offer questions to explore on this?
>
>Chris.
Hilmar made some good points. One table would be easier to code and manage. Descripe your TAGS as needed for your lookup and
sort requirements. VFP offers EXACT OFF to set starts for record groups based on partial keys.
Imagination is more important than knowledge