Adding multiple serial number into one field

[TXH0207]

Hello all,

Is there any way to add multiple serial numbers into one database field and have it listed something like this

Example:
Returned_Equipment (This would be my field)

10010
10070
17010
17035
on and on

Is there another way besides using something like Return1, Return2, Return3 and so on?

I am using Microsoft Access 2000 with Visual Basic 6 Pro.
Still trying to figure all this database stuff out.

Thanks in Advance,

Mike

Mike Haas

 

[johnwm]

For a clear and simple description of databas edesign try:

http://www.alphabetcitydataworks.com/fundamentals.htm

________________________________________________________________
If you want to get the best response to a question, please check out FAQ222-2244 first

'If we're supposed to work in Hex, why have we only got A fingers?'

http://www.essexsteam.co.uk

for steam enthusiasts

 

[TXH0207]

Thank you very much for this tutorial, very helpful.

Take care,

Mike

Mike Haas