Hi all,

I've just finished making a new Registration/membership database for a science fiction convention..

Now, I've just found out that there is a mailing list that has the name and address of all of the former attendees.

Since around 75% of the people who are going to attend the convention this year are probably in that mailing list, I was wondering if it would be possible to write a script that would allow the user to do the following:

From the registrationDB -- type in a persons name, search the MaillingListDB and return a list of matches, let the user pick out the correct one (if there is one) and copy the address fields onto a new recored in my RegistrationDB.

This would save a lot of typing and really help speed up the registration process at the convention.

My thanks in advance -- any and all help will be greatly appreciated.

There are a couple of ways to do this. I'm going to suggest and explain the filtered portal becuase I think it's easier to code scripts and has a better interface. The cals look complicated but are actually pretty straight forward.

First, go into your MailingListDB and create a new field called NameFilter that is a calculation field with a text result. Set its calc to:

"1" & "

Thanks Chuck, that was extremely helpful.

One thing: Every time I try to import a recored I have to realign the fields again -- is there some way to get the import fields to stay the way I set them?

And yes, I know I'm breaking relational theory with this one. There just isn't time to redo it before the convention.

Thanks again for your help.

is there some way to get the import fields to stay the way I set them?

Yes, all you have to do is put the "Import Records" command in a script, then check the option to "Restore". This forces the script to remember to presently used import settings.

Whenever you want to perform that import, you will use the script.