MIVA

[robwood]

I'm trying to store my MIVA products export in Microsoft Access. One of my
first challenges is the category codes in MIVA. Each product can have several
category codes. So I created a table with the category codes: i.e., AI = Acme
Imports, M1 = meditation, etc, based on my categories in MIVA. How can I link
data from the Product table that looks something like "A1, M1, M, ACSS" to
the categories?

Thanks,

Robert

 

[John Vinson]

I'm trying to store my MIVA products export in Microsoft Access.

What's MIVA? I'm not familiar with the acronym.

One of my
first challenges is the category codes in MIVA. Each product can have several
category codes. So I created a table with the category codes: i.e., AI = Acme
Imports, M1 = meditation, etc, based on my categories in MIVA. How can I link
data from the Product table that looks something like "A1, M1, M, ACSS" to
the categories?

Well... DON'T. Fields should be atomic, and have only one value.

Instead, create a ProductCategory table with fields for the ProductID
and the Category. If Product 31 has the above categories, there would
be four records in this table:

31 A1
31 M1
31 M
31 ACSS
32 ...

etc. You'ld enter (and view) this data using a continuous Subform; the
values in the table could be concatenated into a comma-separated
string using the VBA code example from

http://www.mvps.org/access/modules/mdl0004.htm

John W. Vinson[MVP]