I have an Add record screen with two lookup drop downs based on SQL queries.
Query A ensures that only records with a date stamp greater than GetDate() and having never previously been selected are displayed.
[indent]"WHERE (NOT (TokensLeft IS NULL)) AND (SchBreak > { fn NOW() })"[/indent]
Query B simply filters query A by a field containing one of two possible filter values.
If I do not make Query A dependent upon a value in Query B everything works fine and the Query A drop down is reduced by any previously selected items. If I make Query A dependent upon a value in Query B then the list remains static and is only refreshed to the current values in the SQL query by a complete rebuild of the project.
Is this a known issue and if so is there a work around?
EV