Hello,

I would like to ask question for which I didn't find answer. I have several filemaker dbs which differs only by data entered. All tables and fields are same. My question is if it's somehow possible share layout design across all those databases because occasionally I need to modify that layout. Change it in all dbs could be time consuming. Of course I can have empty "design db" where I could re-import data after layout change but again it could be time consuming too.

Also I'm wondering if is possible to use field name (in layout) without any table name and table would be used relative by table defined in layout? (Shows records from)

 

Thank you

 

Maybe you should look into the separation model.

 

Are you referring to sharing your Theme though out the files?

Your Profile shows 12 Advance, have you upgraded?

@Leeno we are still using version 12

@Fitch I 'll take a look 

Separation model working as I wanted thank you for tip. I didn't know changing file in External Data Sources dialog changes content instantly without any extra work. Thank you

Glad I could help. FYI in FileMaker 16 you can now set the data source as a variable, so it can be scripted.

One more recent question. I have replicated my filemaker tables also in mysql. All names (tables & fields) are same. I've also keep same creation order but  when I change my data source to mysql via ODBC connection all relations gets screwed. That means wrong fields are connected between tables. Any hint how to fix it? For migration I've used FM pro Migration proggie.

Thank you 

EDIT: it seems custom order causing this problem and need to check that out

Edited July 26, 20178 yr by AlesD

On 6/22/2017 at 8:56 AM, Fitch said:

Glad I could help. FYI in FileMaker 16 you can now set the data source as a variable, so it can be scripted.

Unfortunately this is only possible with Filemaker file not with ODBC source