Forms

[TaylorLeigh]

I have the following Tables:
Organizations - One to Many to subspecialty
Subspecialty - One to Many to Subspecialty Detail
Subspecialty Detail - One to Many to Orders
Orders - One to Many to Orders Detail
Orders Detail

I want to create a form for inputing the information when I receive it. I
used the Wizard and created the form. I want the information to be in a drop
down form so I can choose. The arrows are there and on some of the items I
can see the information, but it will not input the information. On the first
two tables, I cannot see the information at all. What am I doing wrong?

Thanks,

 

[John W. Vinson]

I have the following Tables:
Organizations - One to Many to subspecialty
Subspecialty - One to Many to Subspecialty Detail
Subspecialty Detail - One to Many to Orders
Orders - One to Many to Orders Detail
Orders Detail

I want to create a form for inputing the information when I receive it. I
used the Wizard and created the form. I want the information to be in a drop
down form so I can choose. The arrows are there and on some of the items I
can see the information, but it will not input the information. On the first
two tables, I cannot see the information at all. What am I doing wrong?

Thanks,

Probably just using the very limited and unintelligent Wizard to do a task
beyond its capabilities.

You say "the information" - but you don't say what information; you describe
several tables but don't indicate which of them you are using as lookups and
which are for new data. At a COMPLETE GUESS, I'd suggest that you want a Form
based on Orders, with a Subform based on OrderDetails and another subform
based on SubspecialtyDetail. On that subform you'ld have a combo box based on
Subspecialty. But I don't know your business model or what a "subspecialty"
really is, so I might be off track.