pasword generation and saving

[concrete]

i'm making a filemaker file with a list of people.

each having a username and pasword (among a lot of other things)

a part of this database i will be uploading to a mysql database on a webserver (with a simple seperated list in txt format).

I'm making the filemaker thing because the webinterface has only got a small portion of the information.

but the webinterface will be using the loginname and pasword from the user file to let people log in.

my question

----------

can i encript the paswordfield? with a script when I'm exporting it to a seperated txt file. (so i don't send the paswords onencrypted over the web)

how can i make a generate pasword button?

thx

[BobWeaver]

Yes you can create some kind of calculation field that encrypts another field, but then you need to have the inverse function on the mySQL server to decrypt the password. Will you be able to do that? You might be better off encrypting the entire file that you upload, or use ssl to connect to the server when you do the upload.