Sub Datasheets

[Redragon]

Hi all,
I'm having a problem with creating a subdatasheet which contains around 10
different values and I'm trying to add all of them to a single field in
another datasheet. So, I have several datasheets which I want each 1 to be
linked to a single field in the main datasheet. Can some one help?

 

[John Vinson]

Hi all,
I'm having a problem with creating a subdatasheet which contains around 10
different values and I'm trying to add all of them to a single field in
another datasheet. So, I have several datasheets which I want each 1 to be
linked to a single field in the main datasheet. Can some one help?

WHOA.

You're *way* off track.

For one thing, datasheets are not suitable data intraction tools for
anything other than debugging.

Subdatasheets are of *very* limited utility and (for one thing) you
can't have but one subdatasheet in s datasheet. However, you can have
dozens of Subforms on a Form if you wish.

But most important, if you are trying to add ten different values to
one field, you're on the wrong track with data normalization!

What is the structure of your table? What information do you have in
the related table (or tables)? How do the two (or more?) tables
interact?

John W. Vinson[MVP]