Storing Integer array in DB

[Nikolay Petrov]

What is the best method to store an Integer array in MS Access DB

example
class testClass
public ID1 as integer
public ID2 as integer
public Data() as Integer
End Class


db fields:
id - integer
ID1 - integer
ID2 - Integer
Data - ???????

thaks in advance

I need the ID1 & ID2 fields, because I query the db against them.

 

[Ron Weiner]

Sounds like a new table with the tried and true one to many relationship

Table1One
OneID (Autonumber PK)
ID1
ID2

Table2
ManyID (Autonumber PK)
OneID
Data