2. PHPRunner General questions
  3. Autofill
This topic is locked

Autofill

8/11/2021 2:36:25 PM
PHPRunner General questions
L
 leteck author

Autofill not working if I use sql variable on where expresion.

autofill Bedrooms - bedrooms

in WHERE I have :
custid=':master.clientidclient'

and dropdown is dependent on:
Buildingcode
Buildingcode

If I dont use custid=':master.clientidclient' it populate bedrooms in autofill, but show all customers apartments when I want only apartments of customer (Master Table).
D
 		DRCR Dev 8/11/2021

Whats stopping you from using the :master.clientidclient here? I'm guessing you need more data in the original query and to filter it down later?
img alt