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