DBLookup on web with Reader fields

Hello everyone,

I have two databases. Database A = Transaction and Database B = Client List.

Client List is controlled via Reader Field

What I want to have happen is this…

Transaction database form is opened with Query String URL giving an account code. A transaction screen is displayed, and a dblookup is used to pick up some details from the Client List.

This works 100% is the Client has already logged into the Transaction database as their Reader field code, as it filters out their entry in the Client list.

However, if the access to the Transaction Database is Anonymous (ie they have not logged in), then the server does not see ANY entries in the Client List.

So, how can I keep the access at the Transaction Database as anonymous, but still allow the browser to pickup the correct entry from the Client List (without breaking security) ?

Thanks in advance. If you need any more information, please ask.

Chris

Subject: DBLookup on web with Reader fields

Do you need to only display the Client list, or use the data in the transaction form?

If you need to use the data, I cannot imagine a way without login.

But if you only need to display it, you may split the data to two parts - Transaction form, and client data.

Client data would be displayed either in a button popup using a form that has a role or whatever necessary to use it - will prompt for login, or maybe in another frame/iframe, with security turned on too.