run the attached bsv which achieves what you want (the flexibility for the LoanWriter.Name to either be manually entered or picked from a list of StaffMember's), by way of 1b. below.
note: Shortcuts have been added in the Customer object so the 3 Name fields which are part of the criteria will also appear in the Query display.
There seems to be a bug (or perhaps just the way it is in Aware) with queries like the one you have, where any of the attributes involved in the criteria are Plain Text attributes whose value has been set to also (as well as just typed in) be determined via 'Dynamic choices':
'Use existing attribute values as choices'
'Choices are determined by a query..'
This seems to cause some kind of conflict or is a bug, and the query won't run properly.
I think you might have mentioned in another Topic that your query worked when you changed the setting for one of the Name attributes from 'Dynamic choices' to 'Static choices'.
Possible work-arounds are:
- Leave the LoanWriter.Name Plain Text attribute (so value can be manually entered if necessary) set as 'Static choices', and:
...a. always have its value be manually entered; OR,
...b. add a Reference Attribute to LoanWriter for Staff which appears before the LoanWriter.Name form field, and whenever the Reference Attribute is changed a dynamic rule would get the value of the Reference Attribute's Name attribute and write it to LoanWriter.Name.
If LoanWriter.Name is subsequently changed manually, then to avoid confusion, a dynamic rule (maybe integrated into the same rule as above) would change the value of the Reference Attribute in LoanWriter for Staff to be UNDEFINED.
...c. add a Button next to the LoanWriter.Name form field which runs a Process which uses PICK FROM to popup a list of Staff to select from. After selection the Action LoanWriter.Name=Staff.Name would happen.
OR,
Change LoanWriter.Name to instead be a Reference Attribute to Staff, which means that any Loan Writer would have to be setup as an instance of Staff. However you could have an 'Add New' button next to the field.
