Enter result according to drop down list

[frosty]

Hiya,

I'm very new to all this, I'm trying to write a DB to record lab results within a specification limit, and run a report to print the results on a certificate based on an automatically generated batch sample number.

In tables I've managed to get a drop-down list for the 'product type', and another for a list of the tests associated (multiples allowed) with that particular type fluid type. What I'd then like to do is add result/values for each of the tick boxes selected. Currently I just get a list of the tick boxes selected.

Sorry, if this isn't too clear! Currently I have:

Name (select from other table)
Fluid Type (select fluid 1 to 5 from another table)
Test (test 1, test 2, test 3, test 4... ...test 8) this is where I can select multiples from tick boxes



I'd then like to type a result for (e.g.) test 1, test 4, test 6 or whatever tick box was selected. Is this possible??

I realise a workaround would be to list all the possible tests as columns and just fill in the relevant column.

Better still would be to select a fluid type, and this opens another form with minimum and maximum allowed values, where I could enter the data - can I do this and keep unique IDs for each sample?

This is with access 2010, I'm starting to find my way a little but need lots of help!!


Many thanks in advance.

[NoellaG]

Hi,

I get the feeling there is something wrong with your database structure. The testresults should be in a separate table:

Normally you can have a table with products, a table with all possible tests and then a linking table ProductTestresults with a 1 to many relationship to each of the other tables.

Before starting to create a database solution, always spend some time learning the relational model and the normalization rules.

succes
NG

[frosty]

Thanks for the response NG. So rather than having a single table with all the results from all of the products in -I'm better off having tables of results relating to a specific product?

Sorry if I'm being stupid, this is very new to me!

Any information is useful, and thank you for your time so far.

[alansidman]

Here is a link on the fundamentals of database design. Read it and then consider how your current database needs to be amended. Post back with questions.

http://www.deeptraining.com/litwin/d...aseDesign.aspx

Alan