A
AshGrant
Hey guys,
I have been given a job to create a database application for accounts
purposes.
The database will evolve around a single table called trial balance which
will contain every transaction put through the system.
This will be populated by a series of APPEND queries which append data from
lots of sub-tables and append two entries each - one credit and one debit.
Is this a good idea of how to approach this task? i.e. Using append queries
to populate the main table and all the reports being generated off that table
with other sub tables for extra detail which may be needed?
Suggestions and comments please...
Ash.
I have been given a job to create a database application for accounts
purposes.
The database will evolve around a single table called trial balance which
will contain every transaction put through the system.
This will be populated by a series of APPEND queries which append data from
lots of sub-tables and append two entries each - one credit and one debit.
Is this a good idea of how to approach this task? i.e. Using append queries
to populate the main table and all the reports being generated off that table
with other sub tables for extra detail which may be needed?
Suggestions and comments please...
Ash.