Help With Left Joins

[DaveyJ]

deleted as wrong post

[DaveyJ]

thanks for your help..

i will re-design the databse using your guidlines.

one last question

how would i restrict the combo box to only show items from the category lists?

[jzwp11]

I would probably use a couple combo boxes on the form, one for the request type and the other for the item selection. Having two combo boxes in this fashion where one is used to restrict items in another is called cascading combo boxes and is a pretty common topic. Roger Carlson has a demo on his site; here is the link

[DaveyJ]

thanks so much for your time and efforts,

working all better now,

still looking into cascading combo boxes

[jzwp11]

You're welcome and don't hesitate to ask if you have questions with the cascading combo boxes.

[DaveyJ]

thanks,

I been trying to achive the cascading combo boxes, with the structure you have suggested

What is the best way to do this if it was part of the request table as a subform with the employee table?

[jzwp11]

As it turns out, the link I provided you used unbound combo boxes. In your case, you need 2 bound combo boxes which can be a little trickier. So, I have attached an example. What I basically did was to set the row source of the second combo in the after update event of the first combo box by using some simple code.

[DaveyJ]

Thanks Mate, your a legend....


with your help, i was able to look at the code and use it in my database.

[jzwp11]

Glad it worked out for you. Good luck on your project.