Recommendations for changing backing table for a layout
I'm no FileMaker expert, so I hope this isn't a silly question.
I'm using FileMaker Pro 10.0v3 on Windows.
I'm making some changes to an existing FileMaker application. The changes include moving the data to a remote database using an ODBC connection. The current use model is that data for a single year is kept in a copy of the database and a new copy is created for each year.
I had hoped that I could have a table per year and change the backing table for a layout and, since the backing tables are structurally identical, the layouts would transparently map their fields to the columns with the same name. This doesn't seem to work unfortunately. I'd rather not make a lot of change to the application or change the user's business process, if possible. Are there any ways to seamlessly change the backing table for either the application or a particular layout?
Any suggestions will be greatly appreciated.