Q: Inputting Arrays into a Form

[Geoff Jones]

Hi

I'm new to Access and was wondering if the possible is possible:

I would like to create a database where each record can contain a list of
numbers. The number of numbers stored in each record is not known in
advance. What I'm trying to do is store an array of doubles in each record.
I need to know how to store an array of such numbers in a record and the
choices I have for inputting the numbers into new records.

Can anybody tell me the best way to do this?

Thanks in advance

Geoff

 

[Dirk Goldgar]

Hi

I'm new to Access and was wondering if the possible is possible:

I would like to create a database where each record can contain a
list of numbers. The number of numbers stored in each record is not
known in advance. What I'm trying to do is store an array of doubles
in each record. I need to know how to store an array of such numbers
in a record and the choices I have for inputting the numbers into new
records.

Can anybody tell me the best way to do this?

The relational-database way to do this is with two tables related
one-to-many. "Each record", in your description is a record in the
"one" or "parent" table, while each number in your "list of numbers" is
stored in a separate record in the "many" or "child" table. Data entry
would be accomplished by having a main form based on the parent table
with a subform based on the child table.

 

[Geoff Jones]

Dirk

Many thanks for your comprehensive answer.

Geoff