Combo Lookup Repost

  • Thread starter Thread starter dan.cawthorne
  • Start date Start date
D

dan.cawthorne

I Didnt Get My Lost Post Answered Correctly Maybe Cause i Didn't
Explain my Self Properly. .

Have a Main Form Named Enquiry_Input, Where The Data Source Is a Query
Which The Query Is a Representation of the Enquiry Table, With An
Addition Project Title Field In The Query ,


The Project QNo Field is a Look Up From The First Column from My
Projects Table, Which Holds all The Project QNo's What Happens Is When
i Select a Project QNo, The Project Title is shown in the Project
Field.

The Enquiry Table Have a Unique ID Called Enquiry ID Primary Key,

But Before a Carry On I Have a Drawing Table, Which is Linked From my
projects Table, Which is Set to One to Many, Which Allows Me To Store
Multiply Drawings To That Project QNo. [Drawing No] is the Primery Key
is This Table.

Next i Have Drawing Link Table, Which Allows Me to Link Drawings To An
Enquiry No.

The Table Consists Of [Enquiry No], [Drawing No]

The [Drawing No] Filed Is a Look Up Combo Which Looks at The Drawing
Table [Drawing No] Field.

The Drawing Link Table Is a Subform on My Enquiry Forrm, So When I
Select Drawing From The Combo On the Subform The Drawings are assigned
to that Current Enquiry.

But What I Cant Seem To Achieve is That The Combo Lookup on for
subform Shows all Drawings for all projects, Which I Know Why Cause
the Look Up Is Set To The Drawing Table.

How Do I Get This Subform Combo Look Up To Only Show Drawings That are
Related To The Project That I have Selected In The Combo Look Up On
the Main Form?
 
Have the RowSource of the combo box on the subform refer to control on the
parent form that contains the project number as a criteria to limit what's
selected.

(BTW, your typing style is extremely hard to read!)
 
Back
Top