Thank you for your help so far. The club gives members a prize after their 10th run, so i'm trying to create a search page that will return the first/last of runners who meet criteria:
sum(runQty)=10, and
(prize_Received) = 0, and
rundate = [today's date] --- each "run record" includes run_Id, user_Id, run_Date (dd:mm:yy), run_Qty (default 1)
Which should return results that include runners who have 10 runs, including one on the specified day, and who have NOT received a prize yet.
I'm struggling with understanding how to create the search parameters in the search wizard. I clearly know just enough about this to understand what I should do, but not enough to understand how to do it. Sorry.
Ideally, the results would simply show the firstname/lastname from the users table, and to really push my luck, i'd like to be able to have a checkbox next to each where i can indicate which users received the prize and update multiple records at once. simply a "1" in the prize_Received column.
If this is too much for the forum, I'd like to setup a 1-2 hour advanced support call for Monday.
Thank you for all of your help!!
