Hello, just joined the forum. I am developing a form where I will enter a sales quote for a customer. I would like to include a ship to code from my shipto table. This shipto code is related to my contact table via the CompanID. The problem that I am having is that when I enter the ship to code using the shipto table as a lookup table, it is giving me the ship to codes for all customers not just the one that I am creating the sales quote for. I don't know how to isolate the shipto code options for this one customer.
Please help! Thank you.