I have 30 databases split between 10 different subjects and 3 different salemen. Each subject is split 3 ways by the first letter of the company name therefore for example one saleman has letters a-g for 10 subjects etc

I want to merge all the databases.

My problem is that at the moment when a salesman searches for a company they only enter data in two fields CALL STATUS and ACTION DATE to find someone that they want to speak to on that day.

When they are all merged they will have to seach for CALL STATUS, ACTION DATE, SUBJECT and ALPHABET (ie whether or not the company is one of their letters)

I want to keep it so they only have to enter values in two fields CALL STATUS and ACTION DATE

I think a way to do this would be to have a log in screen where they would enter which subject they are working on and what the their letters of the alphabet are.

Does this sound like the right way to go about it?:?

And if so how do i create the scipt my main difficulty has been trying to work out how to grab something that the saleman has entered on a log in screen and entering it into their search.

A copy of the current database is attached.

help.zip

A login screen would work, or you could use Status (CurrentUserName) -- but in that case you'd have to make sure their computers were set with the right names.

At any rate, you need to set a global value for subject and alpha. You could do this in your login script or your search script. Login would probably be simpler. Then your search would look like this:

Enter Find()

Set field(alpha, gAlpha)

Set field(subject, gSubject)

Pause

...

etc.

The key is using global fields, as their values can still be accessed in Find mode.

Thanks Fitch, good to know I'm heading down the right road. Global fields - now I've read up of them that solves my problem.

Cheers!