Very basic problem

[Alex Pavluck]

I have been away from ACCESS for a couple of years so I can't remember
how to do the following. Please give me so advice if you can. What I
want to do it make it so that table 1 will have a + at the beginning of
the row and will allow me to click on that plus and it will display all
the values for FORMAT_NAME. Thanks in advance!

What I have:
Table1: DATASET_NAME VARIABLE_NAME VARIABLE_LABEL
Table2: DATASET_NAME VAR_NUMBER VARIABLE_NAME
Table3: DATASET_NAME VAR_NUMBER FORMAT_NAME

So, I can have this:
Table1:
Dataset1 WALK97 Q1. HOW OFTEN DO YOU WALK

Table2:
Dataset1 1 WALK97

Table3:
Dataset1 1 1=Everyday
Dataset1 1 2=Often
Dataset1 1 3=Seldom
Dataset1 1 4=Never

[MGFoster]

Alex Pavluck wrote:

I have been away from ACCESS for a couple of years so I can't remember
how to do the following. Please give me so advice if you can. What I
want to do it make it so that table 1 will have a + at the beginning of
the row and will allow me to click on that plus and it will display all
the values for FORMAT_NAME. Thanks in advance!

Set the table Property "Subdatasheet Name" to the "linking" table.
--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

[amarish.patel]

Open the Table 1 in datasheet view.

Click on Insert --> Subdatasheet, and Click on Table 2 that will create
a + sign also display the values for the FORMAT_NAME.
Repeat same steps for table 3.


Alex Pavluck wrote:

I have been away from ACCESS for a couple of years so I can't remember
how to do the following. Please give me so advice if you can. What I
want to do it make it so that table 1 will have a + at the beginning of
the row and will allow me to click on that plus and it will display all
the values for FORMAT_NAME. Thanks in advance!

What I have:
Table1: DATASET_NAME VARIABLE_NAME VARIABLE_LABEL
Table2: DATASET_NAME VAR_NUMBER VARIABLE_NAME
Table3: DATASET_NAME VAR_NUMBER FORMAT_NAME

So, I can have this:
Table1:
Dataset1 WALK97 Q1. HOW OFTEN DO YOU WALK

Table2:
Dataset1 1 WALK97

Table3:
Dataset1 1 1=Everyday
Dataset1 1 2=Often
Dataset1 1 3=Seldom
Dataset1 1 4=Never