p38
Active Member
Is there any reason why the "where" clause does not work for the front end lookup list option? It shows ALL the records, not the records it should return via the "where" clause.
It works correctly for the normal dropdown list adjacent to the button, ie, returns the correct records in the dropdown combobox.
Anyhow I can debug this?, ie : show the sql of the lookup front options list to check.
The form selected is correct as I can add new options in the correct list
Paul
It works correctly for the normal dropdown list adjacent to the button, ie, returns the correct records in the dropdown combobox.
Anyhow I can debug this?, ie : show the sql of the lookup front options list to check.
The form selected is correct as I can add new options in the correct list
Paul