I have developed a model that the first step is to select records for a table with field name Sales, I manually now change sql expression from Sale 1 to Sale 2 etc, there are about 50 groups of sales. Once the group is selected, it then is joined with a polygon feature Parcels, records copied, join removed and then onto the next group of sales (There are upto 50 sales for each parcel, so a simple join doesn't work,)
I would like to automate the sql expression that initially selects the records, so that once the first group of sales is copied, join removed, the table then selects the next group of sales. Also I need a way to change the name of the copied features to match the sales group, so it doesn't overwrite.
The model works fine now, except that I must manually change the sql expression after each sale group and change the copied features name so it doesn't overwrite the previous sales group.
How can I automate the sql expression, if that is the appropriate approach?