Newbie here---add a variable amount of serial numbers to a table--

[Liverpoolfcfan]

Sorry Folk's,
This might be something very simple but i'm kinda new to this.
I'm trying to set up a kind of inventory database. This database will show all the different batches currently in stock and also the serial number in each batch.
I am trying to figure out if i can a list of different serial numbers to a table.
I want to record all the different serial numbers that come in a batch. A batch can contain anything between 3 and 100 different serial numbers.
I know how to add one serial number but, how can i make this list variable and display all the different serial numbers associated with it?

[aytee111]

It needs to be a separate table, linked to the batches table thru the BatchID, with one record per serial number.

[CodeLiftSleep]

It needs to be a separate table, linked to the batches table thru the BatchID, with one record per serial number.

That would be ideal, but he can also use a plain text string with a separator like a comma or a pipe( | ) between values and then split it into a variant array when he gets it back.

[ssanfu]

That would be ideal, but he can also use a plain text string with a separator like a comma or a pipe( | ) between values and then split it into a variant array when he gets it back.

But that would violate the Rules of Normalization:
First normal form (1NF) http://www.1keydata.com/database-nor...l-form-1nf.php