Help with a (simple) calculation!

[duncs]

First off, forgive me for my ignorance!

I have created a Real Estate database which includes a contact layout, as well as a new purchase property layout. I need to create a script that after a certain date (closing date) copies the address details from the new purchase layout to the contact details (as the client will now have moved to the new house)

I can create a "copy and paste" script, but how do I add the trigger mechanism associated with the closing date? I'm guessing its something like:

If [buying Info::Closing Date > Get ( CurrentDate )]

Perform Script (Closing Day Script)

End If

Am I close??

[T-Square]

Handel--

Are you trying to get something that will automatically run your script? You have three options, I think: first, you could install a plug-in like EventScript and set it up to run as you need it; second, you could have your script run at startup or shutdown; third, you could trigger the script yourself from a button.

To be honest, I think the last option would be most appropriate. Here's why: it seems to me that moving a person into their new house is a Pretty Big Thing (at least it was for me!), and contingent on a whole lot of little things working out. What happens if the financing breaks down? or the buyer backs out? or the house burns down? In each case, the person's closing date passed, but they didn't move in.

Because of that, I would want this transition to be a conscious act, which the 3rd option does.

To make this work, you would just put a button on your Purchaser layout that triggers the script.

HTH,

David