I am designing a dbase to generate reports.
The reports are to be based on requests.
Each Request requests a number of different tests.
The different Tests have different fields and types of results.(Ie I Think they are Different Entities)
The reports that are to be generated are to display the initial request data and the results and details of the different tests.
I swear I have bent my head trying to figure out how to associate the requests to the Tests.
Could someone please offer a solution.
At the moment I have A Request Table and Visual Test Results Table, Ultrasonic Thickness Test Results Table and A Dye Penetrant Investigative Test Results Table.
I want to link them back to The Request Table in a way so that one or more may be selected and associated with each request.
If some one has a suggestion please post it because I'm snookered.