Creating sub-records from a main record.

[Guest]

I want to be able to take a lot code and break it up into 50 seperate items
refferencing that lot code number. Then adding a new lot code and do it all
again. Is this possible? Thanks for any information on the subject.

 

[A C]

I am slightly confused by what you are asking for, could you give us an
example (perhaps simplify into 3 rather than 50 separate items) of what you
would like to do. Do you need a unique "id" for the new items referencing
the original lot number? or can they be the same.

For example (lets assume 3 rather than 50), if A, B, C are all original lot
numbers do you want

1 A
2 A
3 A
4 B
5 B
6 B
7 C
8 C
9 C
:
etc

or do you want

1 A
2 A
3 A
1 B
2 B
3 B
1 C
2 C
3 C

Are you putting these into tables? I think you can achieve either of the
above very easily using queries rather than code, but if you flesh out your
requirement a bit more then we can give you the best soln.

Regards
AC