Very Critical Issue?

[cap.zadi]

Hey dear,

Is there some one who can help me on this matter. I am preparing a database for the lab. tests and had done for some already the issues is now for some kind of tests which cant be design so far frm me.

The field of requirement are like.

File_No (which is given as computer no and the cabinet file too)
Test_ID
Test-Name (and some other info related to this test)
Techn_Id
Techn_Name
Test_No
Time of test
Dated

here is now information for test sheet which is part of above test gen. info.

Sample No, Reading1, Reading2, Stnd's, Results

1 120 125 122 Passed
2 122 121 122 Passed


so how to manage this detailed part under the one heading part as above.



please advise.

thanks.

zee

[June7]

Are you saying these 2 Samples are for the same Test_ID, meaning multiple samples for each Test_ID? If so, data structure probably should be like:

tblTestInfo
TestID
TestName
other info fields

tblTests
FileNo
TestID
TechID
DateTest
TimeTest

tblTestResults
FileNo
SampleNo
Reading1
Reading2
Stnds (if standards always same, put this in tblTestInfo)
Results

tblTechInfo
TechID
LastName
FirstName

BTW, recommend no spaces, special characters, punctuation in names.

[cap.zadi]

Hey thanks for this detail. yes those samples are part of a test and those can be more than one and its always performed under 1 test name and also under one test no (auto number) there will be diff samples like 3-4 on same date so, i was looking to manage all those sample test on one page report and also to store in database.

[cap.zadi]

so it means all those three tbles will be bring together on one form to perform a test. i am just confuse when we want to do more than one one results under the same information and the date and the test no shud be same so how it can be?

as we seen above the sample no can be more than 2 or 3 so how to have those entires under same info and sequence.?

thanks

zee

[cap.zadi]

actually there are 15 test types i had. so i think 1st two tbles will remain same but the result one will be different for each test bcz each have diff format. so is it possible in this way.?

[cap.zadi]

hello, i have done in the same above said procedure. when i go to create a form to perform a test so access merge tbltests and tblresults into one subform and testinfo is as main form which is fantastic but is it possible to keep hold the values oftbltests too just only under one trasaction tbleresults shud have more than 1/3 entries?

thanks.

zee

[June7]

English must not be your first language, having trouble following your narrative. Can you attach your project for analysis?

[cap.zadi]

file://D:\CPC\CPC\Databases\Design/DB Lab Tests

[June7]

You did not attach the file. We cannot access your computer. Use the GoAdvanced button to get the full post editor then below the edit window is the Attachment manager.

[cap.zadi]

Hey, yes it is.

Its just start to design the database not yet project ready. i will try to explain again what i had prepare in MS Visio design.

TblTestInfo
TestID (There is around 15 types of tests have)
TestName
FiledID (The file number unique for each test)
SectionID (In Which Section it is performed)
StageID (In which stage of that section it is performed)
OccurID (Schedule of Test)
Note

* Note: Have the tables for the FileNo, SectionID, StageID, OccurID.

tblTestsINfo
TestNo
TestID
TechnID
DateTest
TimeTest
MtrlID (There is mtrls which are used for each test seprately)
PrdnDate (Some cases there is finished goods)

TblResultT1
TestNo
SampleNo (Can be many samples under this test )
StndValues
Moisture%
Penetration
Note

TblResultT2 (This Test have only the those readings and only taken frm one sample)
TestNo
SampleNo
MS2.0mm
MS1.0mm
MS0.5mm
MS0.1mm
MS<0.1mm
Note

* The format for each test readings/Results is different from other.

Is it ok with you now plz?

thanks
zee

[June7]

I click on that link and nothing happens.

Table structure seems okay.

[cap.zadi]

Please find here the tble structure.

[cap.zadi]

Hey, plz find here the Access 2007 File.

thanks

[June7]

Looked at the Relationships setup. You have Test1 and Test3 tables - no Test2?

TechnInfo table is related to Test1 but not Test3.

Will each record in Test1 and Test3 tables have multiple child records in the Results tables? If there will be only one Results record, no need for separate table.

The link between Test1 and ResultsT1 is wrong. Both fields are autonumber. ResultsT1 is the child table and foreign key field cannot be autonumber.

Don't understand the nature of StageInfo, SectionInfo, FileInfo, MachineInfo tables but something doesn't seem right about the relationships.

[cap.zadi]

Hey Mr. June,

Actually, there is a series of test T1 - T15, i just deisgn T1 and T3 bcz both have diff format of results. Yes there is multiple child fields and as you can see from the tble design,

T1, there is only test and sample is performed once but where as in T3, there are many samples performed under one TestNo in a day at different times.

Ok understand, sp please advise how this relation can be among those tbles?

Those tbles are represnting the Tests as, in which section, stage and machine this test is performed so we can say this is fix for each Test Type and predefined when launch a new test in "TbleTestInfo".

please advise.

thanks

Zee