changing a date

[bp_travis]

HI there. I am looking for a way to change a date automatically. I have 2 databases. If one date changes in the first database, I want the date in the other database to change as well. I want filemaker to know which record to change by the account #. If I need to be more clear, just ask.

Thanks

[Slobey]

As long as your account numbers are unique, you can set up a relationship between the two files using the account number and then in the 2nd file you make it a lookup or an auto enter calculation replace contents.

[LaRetta]

I want the date in the other database to change as well.

Lookup and Auto Enter (Replace) will not update related tables automatically when referenced from another TO. Simply - a file/table can not see 'changes' happening in another file/table and respond accordingly. You must trigger it with script or plugin. And the myth continues.

In addition, this question is posted regarding vs. 5 and Auto-Enter (Replace) is not available until vs. 7.

There are many ways to go, including writing your IDs to global multiline and GTRR, a Find[] and loop, placing your Main date directly on your related layout or an unstored calculation (so it updates as you wish). How best to accomplish it will depend upon your files (and relationship) involved.

Wanna tell us more about what you have and need? Since they are related, do you really need both dates?

LaRetta

[bp_travis]

What I have is a request for a service card. I want the date that a person requests the service card in one database and then in another database, I want that date to change automatically when they request the card, since the account is in both databases.

[LaRetta]

I want that date to change automatically when they request the card,

Then, whey they request a card, you will need to script setting the other date field as well. Are the two files related on Account Number?

Again I question why two date fields. If they are related, you can simply place THIS date field on a layout in THAT database.

[bp_travis]

So if I just copy the one date field onto the other layout then it would do it automatically, since they are the same field? Yes the Account # fields are related.

[LaRetta]

If the two files are related by Account number, that is correct. You can cross-place any fields you wish.

For instance, while in your related file if you go to a layout which has that date field (from your Main file), FileMaker will even open that main file for you and then display its field data (that date field) for you. Cool, huh?