Another way to look at what I'm trying to do is, I have a list of vendors that I sell products to at different prices. I just want them to auto populate the price per selected vendor & product.
Novice
Windows 11 
Office 365
Another way to look at what I'm trying to do is, I have a list of vendors that I sell products to at different prices. I just want them to auto populate the price per selected vendor & product.
Very Inert Person
Windows 10 Access 2016
I dunno; I envision tblCustomers, tblProducts (or whatever you want to call that which you are providing at a price) and tblCustProds. Main form contains customer data, subform is based on tblCustProds. You choose products from combo that lists products and in the same record, enter the negotiated price in a textbox. See what others think.
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.
Novice
Windows 11 Office 365
I could have my description/price table ridiculously long and do a cascading combo box where it filters out just that list of specific customers description/price.
Moderator
Windows 10 Office 365
TNorvell,
Did you find a workable approach? If so, perhaps you could post it for others who may have similar issue.
Posting Permissions
Reply With Quote