Import a multi value field

[csrjw]

I am designing a new form and need a method to import a multi value field. For example, I have a field called "Products" that I want to import into. My data set has values such as Product1, Product2, Product3, etc. What is the best method to design the field to allow multiple value import? I want all the product data to be contained in the Product field.

[Inky Phil]

You can set up a table which includes the field 'product' and import your data creating a new record for each product

hth

Phil

[csrjw]

Thanks but I do not need a new record for each product. A customer has multiple products associated with their account. One record containing a "products" field with multiple product values. Does my import file need special formatting to indicate a multi value field (such as a comma or semi colon?)