combo box prob

[ILA]

ok, i have 2 combo boxes,

I have these tables,

users table[u_id, fname, lname]
company table [c_id, c_name, address,s_id]

user & company link table[u_id, c_id]
supplliers table [s_id, s_name]
products table [p_id, s_id, p_name]


ok, when the user uses the form, they select their user name from a combo box, after selecting another combo box updates which now should contain the companies he/she belongs to, after selecting the company he/she belongs to, another fields updates, saying the supplier the company can order from,

from that, a subform, only displayes the products that supplier provides...

how can i do this?

i hope someone can help...

 

[bjackson]

you could create some stored queries to suit your combo box
criteria.as each combo box is updated you would put in the
after update event for that combo box
me![thenextcombobox].rowsource="the name of the query that suits the next combo box"
me![thenextcombobox].requery
it would be advisable to have a default rowsource in each
combobox as well in case of empty recordsets

hope this may help

 

[ILA]

thanks I'll try this out