Automatically create records in one-to-one-relationships between external and internal tables?

[ah]

Hi, I am modifying an external database with the help of Filemaker (11 Advanced), and thus often need to have a related one-to-one table so that I can make new fields, especially calculation fields.

I do not have a problem creating a new record on a layout showing also fields from the related table.

I do, however, have a problem keeping an updated set of the related FM-tables when they only exist of calculations (+ the foreign key/ID).

The external database is also edited from other users and machines, so that new records do not necessarily come from within a FM-solution.

Until now, I have updated these tables by exporting data from an external table, and then imported it into the FM-table.

But I am starting to get quite a few FM-tables as well, and this just makes a lot of extra work.

Is there any way to make one table automatically update itself in relation to an other, so that there will always be the same number of records in the FM-tables as in the external tables?

Or a simple way to script this, so that all the related one-to-one FM-tables can be updated at once with a script or so?

I know Filemaker is not supposed to be used mainly as a front-end system, but for me, who does not know php, prefer FM to SQL and find the commercial back-end solutions for the external database solution cumbersome and timeconsuming to work with, using Filemaker in addition really makes my life easier.

Apart from the problem that many of the solutions I am used to, demands additional fields - fields that i am not able to make in the commercial database, so that a related FM-table seems the easiest solution...

[ah]

nobody that knows of a script or something that can make sure there is a record in the FM-tables for every record in the related SQL-database?

[ah]

is this really impossible to do, or is the question so badly formulated that nobody understands what I am trying to ask for?

[comment]

For myself, I don't understand WHY you are trying to do this. Wouldn't supplemental fields serve your purpose?

http://www.filemaker.com/11help/html/odbc_ess.20.9.html#1027889

[ah]

For myself, I don't understand WHY you are trying to do this. Wouldn't supplemental fields serve your purpose?

http://www.filemaker.com/11help/html/odbc_ess.20.9.html#1027889

I had no idea that was possible, I didn't dare to even try doing anything in the external tables.

Thank you so much!