grinder332518
Registered User.
- Local time
- Today, 21:02
- Joined
- Jun 22, 2009
- Messages
- 28
I have table 1 (t1) with 2 fields (f1) & (f2).
I have table 2 (t2) with 2 fields (f1) & (f2).
I have a one to many relationship set for t1.f1 and t2.f1.
I need to design a form to show these records, with all occurrences of t2.f2
on the same screen as t1.f1 & t1.f2.
I thought I could use a subform for t2.
In Form Wizard, I select t1.f1, t1.f2, and t2.f2.
But when I click Next, I do not get the screen which starts :
“How do you want to view your data?”.
So I cannot select the “Form with subform” option.
Instead, it goes straight to the “What layout” question.
I have double checked the relationship, and it is as described above.
I have table 2 (t2) with 2 fields (f1) & (f2).
I have a one to many relationship set for t1.f1 and t2.f1.
I need to design a form to show these records, with all occurrences of t2.f2
on the same screen as t1.f1 & t1.f2.
I thought I could use a subform for t2.
In Form Wizard, I select t1.f1, t1.f2, and t2.f2.
But when I click Next, I do not get the screen which starts :
“How do you want to view your data?”.
So I cannot select the “Form with subform” option.
Instead, it goes straight to the “What layout” question.
I have double checked the relationship, and it is as described above.
