Hi all
I have been trying to modify a sample database to suit what I want to do but I am getting stuck on the very first part cascading combo boxes i want to open a form and add multiple items to a table - first i want to select, from a combo box a department - then select a supplier from all the suppliers/maufacturers related to that department then select a stock item based on the description from all the items available from that supplier
I have attached the database I am using to modify and my database
I would creatly appriciate if someone could get me started and pointed in the right direction the original databased used table and I'm using query's so not sure if what I am trying to do will work - I have looked at so many examples I am getting my self confused (I don't expect someone to do it for me but would just really appricate some guidence)
Cheers Guys
Jackie