looking up info in one DB and transfering to anoth

[gloerick]

Hello All,

I'm looking for a way to search one DB from a value entered in another..

I have a newaccounts DB that recieves new account info and I would like to populate it by looking up info in another DB based on one of the fields from an entry in the newaccounts DB..

Currently all HIDDEN fields in the DB are passed to it from cookies I set when a user logs in that are setup in a user DB, values I want set a certien way so it is proper when a new account comes in.. As of now I am setting a bunch of cookies to pass this set info around while they are in the DB pages..

I am looking to set maybe one value like name=whatever so when they send in a new account to the newaccounts DB that DB will lookup a record in the user DB with a matching name and then import all values to the new record in the newaccounts db just submited..

This way I can set only a few info cookies from the users DB and when a new account comes in to the newaccount DB it will lookup all the other values I am currently setting cookies for and improt them to the new accounts record.

Any help would be most appriciated...

Erick

[Lee Smith]

Hi Erick,

How are the users accessing these files?

(i.e. Web, FMS, LAN FileSharing, etc.)

Lee

[gloerick]

Web is how pages are being served,

They login with a name and pass, this name and pass is simply a find request on the users DB, it finds thier record then passes the info to the results page which in turn sets all the cookies for that user.

It works fine but you have to login to the DB to add new accounts because some of the cookies info are required and can not be changed by the person loging in.

If I can get it to find all this info in the users DB from one or just a couple of cookies when a new account is sent in to the new account DB from them I could allow a much more free system to them to send in new accounts and not lose control over some of the fields.

Thx Erick

[Garry Claridge]

You may be able to use an [FMP-InlineAction] to "lookup" fields then set them in a Form.

Good Luck.

Garry