AnsweredAssumed Answered

Changing external data source mysql table

Question asked by RoryDale on Aug 21, 2010
Latest reply on Aug 22, 2010 by RoryDale


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...