patpai

Shadow tables in FileMaker

Discussion created by patpai on Jun 7, 2012
Latest reply on Jun 7, 2012 by DrewTenenholz

Good morning again,

 

Im trying to understand how -up-to-date a shadow table keeps itself.

 

Here is what i did so we are all on the same page:

 

I created an External Data source in FMP that uses an Oracle ODBC.

 

Then, i went into managedatabse elationships and pressed the ADD table button.

then i selected the Oracle ODBC from the data source drop-dwon menu and selected the right view from oracle that i need data from.

 

So i know have 1 table on my relationship diagram page and 1 layout was created by default for that 1 table with populated rows.

 

I then moved to the tables TAB and i can also see 1 table showing, with the slight difference that it as a SYNC button.

The sync button when pressed seams to be able to sync to that oracle table and return any new fields that might of been created since last i checked.

(im assuming at this point based on mesaage)

 

My question is this:

 

Is my shadow table in a LIVE-SYNC mode with oracle table? Do i need to refrsh that layout (so-to-speak) in order to keep the data in that shadow table updated?

 

Or is it a LIVE-SYNC and any changes made on that ORACLE table (record wise) will right-away show into that shadow table?

 

Thank you very much, please dont hesite to ask for more info if you need too

Outcomes