I've only been using Filemaker for fairly basic tasks (invoices, contacts, etc) until recently. Now I am building a FMP database to manage a bunch of different tour groups and their itineraries. I've built a front page, with a months worth of date fields, 36 to be exact, that can be "scrolled" up and down using a simple script. Then, using the relationship table, I've created 2 towers of 36 related fields (this was quite tedious!) to enable me to show where 2 tour groups are on a particular day. All fine and good. But I have been playing around with ExecuteSQL to do the same as the relationship tables to save me all the hassle of building more towers. Potentially we might want to show up to 5 or 6 tour group's location at once and it would be nice to be able to add more at a click of a button.
I'm not familiar with SQL at all, but I was thinking it must be possible to do something like:
ExecuteSQL ( "SELECT TourDateLocation FROM TableOfTour WHERE DatesonDisplay_&$RowNumer = TourDate & Overview1 = Tourname" )