I have a problem with a custom view. I have two tables. one table (Customers) has fields cust_name , cust_ID, cust_address, cust_town and EmployeeID. The other table (Display) has fields customer, cust_ID , cust_address , cust_town , EmplyeeID and other non related fields. I have set in the (Display) table the field cust_name as a lookup from the (Customer) table . The cust_ID ,cust_address, and cust_town are setup to be dependant upon the cust_name .
The records in the Customer table contain two identical records except for the key field and the EmployeeID field, as there are two employees for each customer.
When adding a record on the add page (Display) table , I have the cust_name field set to edit box as Ajax . I have an expression to show the cusotmers with the EmployeeID; so in reality there are two customers that have identical data (cust_name,cust_ID,cust_address and cust_town) except for the key field and EmployeeID . The Display field is setup to show expression cust_name + '' + EmployeeID; to differentiate between either employee when choosing customer. Here's where the problem is. After typing in (ediit ajax control) and selecting one customer; the dependant dropdown fields are populated with both records data. ex.. there are 2 cust_ID's ,2 cust_address ,2 cust_towns which are identical etc.. I would like to show only the data from the record selected.
Is there a way around this without changing the whole structure of the tables. version 6.1 build (2503)
