filtering in a list box?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

i am making a meat distribution database. In the order form i have a
dropdown list of all the weights in my warehouse. how do i make the dropdown
list show only the meat that hasnt already been odered by other customers???

Should i use a combo box??

thnx in adv
 
you can simply use the Find Unmatched Query Wizard to select the product that
is not ben sold to the customer with criteria of your customer name from a
TextBox or ComboBox from your form. open the the query in SQL view and copy
the SQL syntax to the RowSource of your ComboBox or ListBox. Every time you
update the ComboBox or ListBox try to refresh the list containing the list of
unsold product,

hope i answered you problem,,
 
Hi thanx for advice. I went onto the unmatch query and when i went to choose
the weights the actual field wasnt part of the list from my weight list. And
in my order form the customers can each have up to 5 peices of meat (orders)
so will that be a problem in matching them to the list of weight in another
table? Can i overcome the second problem by using an 'or' statement?

Thax in adv
 
Back
Top