Is this Possible?

[Res]

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.

[Chuck]

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" & "

[Res]

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.

[jasonwood]

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.