I have a problem with lookup table and autofill, with master / detail.
For the same product I have different prices per customer, I have a product price table per customer.
Use lookup table to select the customer on the screen of purchase orders (master)
In the product table use table lookup to select the product, and autofill to fill in the value.
I'm using parent / filter from the master table for the detail, works fine to select the products, but the autofill ignores the filter, which in the case is the client code.
Mysql Log:
Query autofill: SELECT value AS FIELD0, amount_file AS FIELD1 FROM vw_services_properties WHERE (server_code = 47) ORDER BY ASC_services
Query lookup Table: SELECT AS-LinkFld, AS DispFlds, AS Disp2Fld, AS Disp3Fld, AS Disp4Fld FROM vw_proposals WHERE (proposal_type IN (1)) AND ( client_code IN (100115) ) ORDER BY desc_services ASC LIMIT 0, 10
The autofill Query should filter through the proposal_type and customer_code fields.
Where am I going wrong?