hi All,

i have been asked to create a fm db which is hosted via the www and read only access.

now the information shown is to be taken from another fm database (internal).

so i will export the info from the internal db and export it to the web db.

i will do this via a script or lookup.

Now the problem i have is that it would ideally need to be in real time i.e. when a record in the internal db is modified this immediatley modifys the relating record in the web database.

any ideas on how i can do this/any better ways of doing this?

You can make all the fields in web database calculation:

Name=Internal::Name

Always up to date, no scripts, and real time...

what about creating the records within the web database?

i have a copy of troi plugin and i am thinking of using this to run a scheduled updat eto the database every hour!

You can do that in Internal database on another machine via script.

but at what point would the script run to create a record within the web database?

You wrote: "i have a copy of troi plugin and i am thinking of using this to run a scheduled updat eto the database every hour!"

Isn't that enough?