G
Guest
I have 6 general sections of a group of forms. For ease of example, Section
A, B, C, D, E, & F. Section A, E, & F are pretty fixed in their table fields.
However, sections B, C, & D vary drastically on each paper form. The purpose
of the database is to input paper form data into the database for storage and
reporting. There are 153 forms, and I would prefer not to have a seperate
table to each form, as my database will be gigantic. I will be implementing
the database forms using XML. I was wondering if I can use an XML database
for the variable fields and the the access database for the fixed fields, and
still be able to do reporting by pulling the data from both databases. Maybe
there is an easier way to do it all in Access. Let me know. Thanks.
A, B, C, D, E, & F. Section A, E, & F are pretty fixed in their table fields.
However, sections B, C, & D vary drastically on each paper form. The purpose
of the database is to input paper form data into the database for storage and
reporting. There are 153 forms, and I would prefer not to have a seperate
table to each form, as my database will be gigantic. I will be implementing
the database forms using XML. I was wondering if I can use an XML database
for the variable fields and the the access database for the fixed fields, and
still be able to do reporting by pulling the data from both databases. Maybe
there is an easier way to do it all in Access. Let me know. Thanks.