Hi

Looking for a bit of design help...



I am trying to make a new database that will record report information.

These are done in batches. The batch information will need to be recorded firstly i.e. name, site, date (call this BATCH_INFO). Then the report information needs to be entered (call this REPORT_INFO).

I want to somehow lock the BATCH_INFO down so this does not have to be re-entered for every report.

Anyone got any idea's??? Any help greatly appreciated...