Auto-create Duplicate Records in 2nd DB?

[Steve T.]

Howdy! I'm new to relationships and could not do this on my own or find any examples of it already done (I thought it'd be simple)...

I want a "stripped down" version of a more detailed database for web publishing. FM suggests something like this on page 9 of the FMP Web Publishing Security Guidelines (URL below) and mentions relationships and calculations.

If database A has all my fields, and "stripped down" database W has only those fields I want to publish on the web... how do I make it so any new records created in A are also automatically created in W?

A is the main DB users update.

W needs to be as fully searchable as though searching A, just with fewer fields.

It doesn't matter if W actually stores A's data or not as long as W reflects A's changes relatively (pun) quickly.

Preferably this is all automated without having to be manually "triggered" by user script or something.

General help/direction appreciated. Bonus if you can give me CDML code for displaying related field if not [FMP-field:fieldname].

Thanxalot!

SPECS if need: FMP-u 5.5, mac G4, A: 100 fields/9 layouts, W: 10 fields/1 layout

URL to FMP doc: http://www.filemaker.com/downloads/pdf/WebSecurity072002.pdf

[Anatoli]

IMHO there is not "auto" function in FM, which will "watch" database "A", and if there is new record added trigger auto-new-record-in-db-W-and-populate-that-with-record-just-created-in-db-A.

With script it is easy.

[Keith M. Davie]

"With script it is easy."

Oh I definitely agree. Over the www it is a bit more complicated to run ScriptMaker successfully, but it is doable. Mention was made of "... of the FMP Web Publishing Security Guidelines ..." which would indicate a need to understand the complexities of using the single-threaded ScriptMaker in a multi-user environment such as a browser solution affords.

At my site I also use ScriptMaker to totally remove selected ("priviledged") data from databases which are set for web sharing as a method of additional security. Because of the powerful tool which ScriptMaker is, such data never needs to be stored in a db set for web sharing.

[Anatoli]

There is small difference.

sktajiri need to do it not from web.

[Steve T.]

Thanx, Anatoli/Keith. You two and garry have already helped me several times via other people's questions. We all appreciate the expertise. Keep the info flowin'!

--ST