Best way to Propagate Keys?

February 23, 200421 yr

I'm new to Filemaker and working on a little project and I'm just curious if there's a better way to do what I want than what I have in mind.

What I want is to populate 2 databases from a single Web interface with a shared key. The key is actually comprised of 3 data fields concatenated (together, the first 20 Characters will always be unique)

What I was thinking was, I'd get those three fields along with the rest of the initial data, and then post it to both databases via CDML.. only.. I'm not sure I can do that? Perhaps I could specify the second in an inline action? Or should I store the data input as tokens and push it to a second post? Okay, perhaps some of that should be in the CDML forum..

I guess what I'm asking is.. is there a better way to get the data in both files to begin with? I want this field to be a primary key so it won't work to do a lookup. Is there a cleaner/easier way to get this data in records in both dbs so they relate?

Thanks in advance

Micah