Very basic problem

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Alex Pavluck - 15 Sep 2005 20:13 GMT

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

Reply to this Message

MGFoster - 15 Sep 2005 21:48 GMT

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.

Signature

MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

Reply to this Message

amarish.patel@gmail.com - 15 Sep 2005 21:48 GMT

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.

> 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
[quoted text clipped - 19 lines]
> Dataset1 1 3=Seldom
> Dataset1 1 4=Never

Reply to this Message