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.