Multiple values in a field

[joxo1]

Hi,

I have a database that needs to store (and search by) invoice numbers. I was just going to use a field called 'Invoice_Numbers' however I've found out that there may be multiple invoice numbers accosiated with each record.

How do i store multiple values in a field and be able to search the database for them?

I can just have multiple fields like 'Invoice_Number_1' , 'Invoice_Number_2' etc as I don't know how many invoice numbers there may be!!


If you can help I would be very greatfull!

 

[Schroeder]

Assuming your table contains order information, use a separate table to store your invoice information. Include an OrderNumber field in the Invoice table so that you can relate them back to orders.

Poke around on Google for information on database normalization. This article is a good plain english beginner's guide.

 

[SkipVought]

joxo1,

Your table was not designed by a knowledgeable database professional.

I would CORRECT this situation rather than doing a workaround.

Skip,
[sub]
[red]Be advised:[/red]
Alcohol and Calculus do not mix!
If you drink, don't derive! [/sub]