Supply Receipt Database

[clownfish1980m]

I searched the forum and can't seem to find what I am looking for.

I am creating a supply receipt database with one to muchrelationship. I have created a suppliertable with the following fields:SupplierID (primary key), Manufacturer.I have created a Supply Item table with the following fields: SupplyID(primary key), Supplier ID, Item.I createda main table with all the information for bringing in a supply item with lookup functions going back to the supplier table and the supply item table.What I would like to do is be able to selectthe manufacturer and have it filter out the supply items so the list is not sobig.Example, if I have vendor X thatsupplies item A, B, & C only then when I bring in an item from vendor X,only items A, B, & C will show up in the item field of the input form.

[ranman256]

Make a continuous form of supplies.
in the header ,put a cbo box of manufacturers. The AFTERUPDATE event will filter the records.....

sub cboBox_afterupdate()
If isNull(cboBox) then
   Me.filterOn = false
else
  me.filter = "[manuf]='" & cboBox & "'"
  Me.filterOn = true
end sub

[orange]

Research cascading combo
Here are 2 older free videos that detail the concepts and code involved.

http://www.datapigtechnologies.com/f...combobox1.html
http://www.datapigtechnologies.com/f...combobox2.html

Good luck

[clownfish1980m]

How would I connect this to the main table where my employees would enter the supply items they received? Thanks