AnsweredAssumed Answered

populating data with multiple parameters?

Question asked by malibux14x on Sep 8, 2016
Latest reply on Sep 9, 2016 by coherentkris

Hey there.  I have a database of product from multiple brands and a data base for purchase orders.

 

I currently have it linked to where i type the name of the item into the purchase order and it searches the product database and i click on the correct item and it populates all the info for that item.

 

My product database is growing very large and sometimes the names overlap so i need to add a "1" or something at the end.  Is there a way to say:

 

i create a purchase order for BRAND A and choose BRAND A when i create a new PO so i know its only for this brand.  then the product field will ONLY show items from BRAND A?  Then if i create a PO for BRAND B it will only show items from BRAND B?

 

Sounds simple but i cant figure this one out.

 

thanks!

Outcomes