Changing external data source mysql table
I'm sure this is a quick solution, but I'm scratching my head about it. I have a website that inputs data to a mysql database. I have a filemaker front end to this for viewing and editing the data. Each year, I create a new mysql table and a new filemaker file, duplicating it and updating the database info, so last year was info_2010 and this year will be info_2011.
I can't figure out the easiest way to change my filemaker file to connect to the new database using all the existing layouts and fields, just drawing data from a different table. Every thing I can come up with results in <Table Missing> or ::Field Name suggesting that one by one I have to tell each field where to pull its data from.
There has to be an easier way that I am just not getting. I've tried Layout Setup and Show records from info_2011, but that doesn't work.
Anyone have a quick solution that I'm just not aware of??
Thank you in anticipation...