Anyone experience the below issue.
Below table
Customer Table Fields ID , Customer_Name , Customer_ID , Address , Salesman_number
2nd Table
Display Table
Fields ID , Customer_Name , Customer_ID , Address , Display_Items , slsm_Number etc...
In the display table to add a record I use lookup wizard . My dropdown first or main field is Customer_Name . The Customer_ID field and Address is setup do be dependant upon Customer_Name . I have Customers with the same name ( these are chains with multiple stores ) and multiple salesman that have same customer_name . I use Customer_name as link and Customer_name + '/'+Salesman_number expression for display in dropdown control to deciper to user which record to pick. Note: cannot use sessions in where clause for salesman because some users need to see all customers example ...managers.
Here's the issue. When a user selects a customer_name that has multiple stores. customer_ID field shows multiple Customer_ID's and address's because Customer_Name has duplicate values in Customer Table .
I thought if I checked off Unique values : Only the specific record would fill in customer_ID . If unchecked Unique values same thing happens.
Need to select Customer_Name and autofill only values from that specific record. Note: If I use read only for address it picks the first address in the database; so made all neccessary fields dropdowns.
I am trying to grab only the fields from the distinct record of the Customers Table and master field (Customer_Name) in the lookup wizard.
