Table in a table question??

[Leo]

G'day everyone,

I've been pondering on how to ask this question to the
forum because it sounds confusing but here goes anyways.

I am trying to make this table with 6 fields but each
field has multiple entries say 10 which all belong to the
same record.

So how do you do this in Access?



Any help would be good?

Cheers

 

[Dirk Goldgar]

G'day everyone,

I've been pondering on how to ask this question to the
forum because it sounds confusing but here goes anyways.

I am trying to make this table with 6 fields but each
field has multiple entries say 10 which all belong to the
same record.

So how do you do this in Access?

Any help would be good?

Cheers

This would generally be considered a defective design -- it validates
the rules of database normalization (by storing multiple data items in a
single field), and makes it impossible to query or manage the data via
SQL. You may have a valid reason to do this, but I can't think of one.

The normal way to do this is to use related tables to store these
multiple entries, one record per entry. Subforms are the easiest way to
manipulate the related records manually, though it is possible via code
to assemble and present them as a delimited list in a text box.

 

[John Vinson]

G'day everyone,

I've been pondering on how to ask this question to the
forum because it sounds confusing but here goes anyways.

I am trying to make this table with 6 fields but each
field has multiple entries say 10 which all belong to the
same record.

So how do you do this in Access?

By using Access as it was designed: a relational database.

You need TWO TABLES in a one-to-many relationship; each record in the
first table would be linked to (say) ten records in the second table.

This can actually be *displayed* as a "table-in-table" appearance if
you wish by enabling Subdatasheets in a datasheet view - each record
of the "one" table will have a + icon in the left column, clicking on
it will display all the related records.

Better, though, is to display the data using Forms and Subforms for
the one and many side tables respectively.

 

[Guest]

John Your a legend mate!! That will do the job!

Cheers mate

Leo