I have written a script that will find a certain set of records in another db based on a certain job number. Is there a way to find a set of records based on which password is used. Basically, how do I tell FM to use the password used to login to the file in a script?

The password will equate to a Group, so you should be able to use the Status(CurrentGroup) function in your script.

I have 7 people associated with a group. Each has their own password. I want to be able to search based on who logged in, not based on the group. Is this possible?

No, becuase you have more than one person using the same password. You'll have to give each person a separate password, then associate each password with a separate group.

Alternatively, create your own "log-in" system where people first conenct into a "user" database and perform a find for their own record (username and password). Once done, you can then track the users yourself.