I have 3 tables
Make, contains Names of makes
Model, contains models relevant to Makes
Vehicle, contains id from Make and Model
When creating a new record in the table 'Vehicle' it is possible using a database join to select Make (works great)
Then Model is ajax updated to only show models relevant to make (works great)
When I return to edit the 'Vehicle' record, the 'Make' DBJoin is populated but the 'Model' DBJoin is 'Please Select'.
If I change 'Apply Where When' in model DBJoin to NEW only, then the correct record is displayed but the dropdown is populated with every model for every make, as you would expect with no Where clause.
Is there a way to use where clause when editing?
Make, contains Names of makes
Model, contains models relevant to Makes
Vehicle, contains id from Make and Model
When creating a new record in the table 'Vehicle' it is possible using a database join to select Make (works great)
Then Model is ajax updated to only show models relevant to make (works great)
When I return to edit the 'Vehicle' record, the 'Make' DBJoin is populated but the 'Model' DBJoin is 'Please Select'.
If I change 'Apply Where When' in model DBJoin to NEW only, then the correct record is displayed but the dropdown is populated with every model for every make, as you would expect with no Where clause.
Is there a way to use where clause when editing?
Last edited: