I have a database for my cattle property. I want to search the database for cattle in a certain paddock and property. Previously I used the FindSelect statement in my programme (old statement tolerated in Panorama 6, which had the advantage of specifying the field to be searched in the data).
In the absence of an equivalent option (as far as I am aware), I have set up a TextListObject, with 2 columns and no duplicates, to show the available combinations of Paddock and Property. I then want to select the data matching my selection. However, the Text List allocates my selection to a variable, and I need to search 2 fields to get a match. Any suggestions on how to proceed?
(I’ve tried to create a separate field with the merged Paddock & Property fields, but it keeps bombing, so that’s not an option at the moment)