Thank you for the quick reply... this sorted the syntax error... But, I've not been able to actually achieve my desired goal... maybe you could help with that?...
I've built a list / results page, using DataAssist... I've added some icons into the list, with a cool tooltip that displays more details. Each record in the list is a record from the "Users" table, and contains a field called 'User_DiscCode'. I also have a table called 'Discounts' that contains a field called 'disc_code'. I basically want to be able to display the Discount info (from the 'discount' table) in the tool tip, if 'disc_code' matches the users 'User_DiscCode'. How could I this and make it work for all records in the list?
Does that make sense?