How to keep Record and history of Standard Values of Test Parameters .

[cap.zadi]

Hi there,



I am designing a database for Laboratory Tests and facing problem to design the structure for standard values of Parameters.

Like i have 3 parameters that contain stand limit values:

1. Moisture
2. Ignition
3. Dryness

what sort of structure should build where when i change the limits of stand values for each Parameter so it should apply from that date and also history should be there?


please advise.


zee

[Rainlover]

You need two Tables.

The First describes the test.

The second keeps a Record of the results. A new record for each test.

These Tables should be Linked via The Primary Key in the first Table and the Foreign Key in the Second Table.

A One to Many Relationship.

[orange]

In general I agree with Rain. However, I'd like to see a few examples of the values of these parameters in a few experiments. I'm sure there will be a pattern. You may get into details for unit of measure, percentage concentration.... but a few examples would help.

[cap.zadi]

Hi Sir,

Thanks for the reply and its helpful. I would like to ask the some more questions?

1. How we can add a field to describe the standard limit values of Parameters? As Have seen in my soft wares like; > , <>, Between, Etc and accordingly fields will appeared to write the digital limits?

2. Lest say we update or change the Standard Limit Values, so How will be possible to advise system to take the Values in Queries/reports respectively old and modified since updated?


thanks a lot.

zee

[orange]

Please show some sample data so we're all talking about the same thing.

[cap.zadi]

Mr. Orange, Thanks for concern as well. There are almost 25 no. of Tests to perform at different stages of Manufacturing Process starting from Raw Materials to Finish Goods. Then each test having more than one Parameters to which checked by Lab. Technician and record the information for each.

As said above, so there are standard limits for each parameter. like

1. Moisture Max. 5%
2. Ignition 0.5 to 1.0 mm
3. Dryness 2.0 to 3.0 cm

so i have created a TblTestList, TblParameters which are linked by TestID and a other table for Unit of measure for each parameter TblUOM.

please advise the needful.

zee

[Rainlover]

Are you saying that you do not understand how to add a Field.

[cap.zadi]

No Sir, Lets say last month we decide the standard limits for Moisture 0.5% as Max. but this month we changed into 0.4% so how i can control that if i browse data for last month so it should shows analysis based on 0.5% SLV and this month based on 0.4% SLV.

[Rainlover]

As Orange said.

We need to know more. Please post a cut down version of your Database so we can look at your Tables. Please enter some dummy data.

In particular we would like to see your Table designs and to see if things are Normalised.

[cap.zadi]

Well, ok Sir. i will do that.

[cap.zadi]

Dear Sir, Find the attached database and the form also which i am trying to design for Test maintenance and then there will be other forms to record data for each test.

[Rainlover]

Sorry I did not say this but could you please convert to Access 2003.

[orange]

I have 2003 as well and can not use an accdb formatted file.

When you say one of your parameters (at least)

data for last month so it should shows analysis based on 0.5% SLV and this month based on 0.4% SLV.

you will have to store a date or date range for which a parameter value is acceptable, OR

include such data with your analysis in some manner.

It's much like the Cost of a Product. If you store the cost in the Product table, then how do you change the cost without affecting all previous Sales?? In an Order or Order Detail you can identify the Product and the Cost at the time of the Sale (such a cost could reflect a discount; a preferred Customer price; a clearance Sale; damage Goods mark down...) and would not be associated with Product generally.

[cap.zadi]

Mr. Orange,

Here is main thread which need your valuable help.

https://www.accessforums.net/databas...tml#post144167


regards

zee