If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Forms
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, |
#2
|
|||
|
|||
Forms
On Wed, 13 May 2009 05:41:02 -0700, TaylorLeigh
wrote: 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. -- John W. Vinson [MVP] |
Thread Tools | |
Display Modes | |
|
|