It would be good to have the smart tab search be able to do a lookup on keywords (partial text) to the lookup table and return a selection of matches to the user who can then pick a record.
Use case: list of equipment specs and associated details
Search based on description for example: "air wall" would search where the lookup field with the logic:
select * from lookup where field like %air% and field like "%wall"
The resulting list would then be displayed if matches exist for the user to select.
This would be extremely useful if the user does not know the exact text they are looking for, the result being to return appropriate details for a class of equipment
Please sign in to leave a comment.