I added a CustomerID column to every table, and I want to use it to filter everything based on which customer has logged-in. I have set each data page to filter on that CustomerID field.

I have a table of log-in credentials, which also as a CustomerID column. The problem is that one customer could have many users, each with a unique User ID. How can I look-up the user when they log-in and then get the CustomerID from my credentials table and put it into the UserID so that my filtering will work properly?

I have been having a heck of a time trying to figure out how to allow multiple, separate customers to use the same database.

Can anyone help?

Topher

You need Developer Edition, and Javascript, as well as a lot of custom code.

Then in the Query portion of the project you have to filter over this field.

I have developer edition, but I don't know if I want to do the custom code.

I was hoping I could us the Filter by Username mechanism somehow. Dang.

How do people usually do this? Surely it is a common requirement?

Anyway, thanks for your help!

You can use the filter by function with a field, but when you have multiple userid's per field, then you need custom code.
No way around.