I have a database that lists controls in an accounting department (Table1).  
These controls are tested in another table(Table2).  The problem is that each
control will have varying results from the test.  For example, in one test
the Accounting Managers signature on the monthly report is proof of the
control thus a month field and a Y/N.  In another control invoices are signed
off by department managers.  So, a sample of 30 invoices is selected.  For
proper documentation the invoice number, venderID, vendor name, date, amount,
and signer initials are needed.  I am not sure how to structure Table2 to
handle an unknown result.  I can use one-to-many for the different sample
sizes, but the fact that one result can be 30 records with 8 columns and the
next is 2 records with 2 columns!

Beyond only having text fields and having the tester put in a number of
fields required 8 or 2 in the example above, I am stumped.  In Excel I link
to the Access table and import the fields describing how to perform the test.
Then, the user format the lower portion of the form and inputs results in
whatever format works.  Then, after the test, the tester puts pass or fail in
the Access database results table (table3).  But, I would really like to have
all info in the database vs. some in Access and some in Excel.

Thanks!