HELP PLEASE!
could anyone have a look at this DB.
basically what i need is a form for entering details about suppliers, product categories and products. i have set up 3 tables, supplier, category and product.
i have on the main form, supplier details and on the sub form category and product details.
i would like to have both category and product as combo boxes. i need these set up so that the user can select from a list or enter a new one if its not on the list.
i would like for the user to select prodcut based on the category selection..
does this make sense to anyone!!
any help greatly appreciated
cheers
paddy
could anyone have a look at this DB.
basically what i need is a form for entering details about suppliers, product categories and products. i have set up 3 tables, supplier, category and product.
i have on the main form, supplier details and on the sub form category and product details.
i would like to have both category and product as combo boxes. i need these set up so that the user can select from a list or enter a new one if its not on the list.
i would like for the user to select prodcut based on the category selection..
does this make sense to anyone!!
any help greatly appreciated
cheers
paddy
