Use Button to Run a Script that will create a record and copy a field in a seperate table

[Bmiller4evr]

I have a database that contains customer information. I need the ability to look through my records in form or list view and click a button next to any record that will include this record in a new table that i am using to produce a mailing list. I know how to edit the layouts and put in the button, and I have the table for the mailing list created such that if I create a new record by hand and type in the account number, all of the fields that I need get populated from the original record. But what I do not know how to do is write the script that will create a new record in the mailing list table and copy the account number from the record i selected and paste it in the account number field in my mailing list table.

If anyone feels like earning bonus points, and who doesn't? I also have a field for recording the date that the Customer was added to the Mailing list. 10 points if you can throw in the script to populate that field when the button is clicked as well.

[Matthew F]

Its sounds like you've already figured out a way to do this. What goes wrong when you try to make a script to do this?

For example:

Set variable ($AcctNum ; Customer::AccountNum)

Change Layout (Mailing List)

New Record

Set Field (MailingList::AccountNum ; $AcctNum)

For your bonus point, just use the script step: Set Field (FieldName ; Get (CurrentDate) )

[comment]

include this record in a new table that i am using to produce a mailing list.

Why do you need another table for the mailing list - instead of marking customers as included (preferably by populating a date field)?