[RESOLVED] Table relationships

[Monti124]

HI,
Can any one help me with this?,
Iam trying to create a database with the following fields
LOT NUMBER
TEST
GENERATION
RESULTS

What Iam trying to do is create a one to many relationship. where I have
one Lot Numbers and Many test then I want each test to have Many Generations
And Each Generation to have one result.

Example
Lot Number A
test1,test1,test3, ect.

TEST1
GenerationA
GenerationB
GenerationC

GENERTATION A
Result 1
GENERTATION B
Result 2

any help would be appreciated

[GaryMazzone]

Table 1 LotNumbers
LotNumberId PK Int
LotNumber Varchar(50)

Table2 Tests
TestId PK Int
LotNumberId FK to LotNumbers
TestName Varchar(50)

Table 3 TestGenerations
TestGenerationId PK Int
TestId FK to Tests
TestGenerationName Varchar(50)
TestGenerationDate DateTime

Table4 TestGenerationResults
TestGenerationResultId PK Int
TestGenerationId FK To TestGenerations
Result

[Monti124]

GarryMazzone, Thanks for your reply, this is exactly what I was looking for.

Monti124