Access access form design

Joined
Jun 19, 2009
Messages
1
Reaction score
0
I am designing a form which uses 2 tables :

T1 consists solely of one field with the main reference number.

T2 consists of field1 which matches T1, and also Field2 and Field3,

Field2 is an incremental counter, and Field 3 is the corresponding text.

Not all entries in T1 need have matches in T2.

Eg

T1 aaa,

bbb,

ccc

T2 aaa 1 hello

T2 aaa 2 how

T2 aaa 3 are

T2 aaa 4 you

T2 ccc 1 good

T2 ccc 2 luck



I need to design a form whoe output will look like



Aaa

1 hello

2 how

3 are

4 you



bbb



ccc

1 good

2 luck



With the wizard, I get an individual page for each T2 item, which is not what I want.

I am a complete beginner, and going on a course isn't an option.
Thanks in advance.
 
Hi

I don't quite understand how your data is laid out but I suggest you create a Query - select the 2 tables and then link the like fields from T1 to T2. Select the field you want in T1 - hold the mouse button down and drag it across to the corresponding field in T2. Play around with the query until you achieve the result you want - save it and then create the form from the saved query.

Hope that helps
 
Back
Top