 |
 |
 |
|
It is currently Wed Feb 20, 2019 8:45 am
|
|
Page 1 of 1
|
[ 4 posts ] |
|
Need help with Filter Data by UserName
Author |
Message |
topherfox
Joined: Thu Aug 07, 2008 12:39 pm Posts: 69
|
 Need help with Filter Data by UserName
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
|
Mon Aug 09, 2010 6:15 am |
|
 |
dean
Joined: Sun Jun 07, 2009 8:54 am Posts: 65
|
 Re: Need help with Filter Data by UserName
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.
|
Tue Aug 10, 2010 3:36 am |
|
 |
topherfox
Joined: Thu Aug 07, 2008 12:39 pm Posts: 69
|
 Re: Need help with Filter Data by UserName
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!
|
Tue Aug 10, 2010 6:47 am |
|
 |
dean
Joined: Sun Jun 07, 2009 8:54 am Posts: 65
|
 Re: Need help with Filter Data by UserName
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.
|
Tue Aug 10, 2010 6:51 am |
|
|
|
Page 1 of 1
|
[ 4 posts ] |
|
Who is online |
Users browsing this forum: No registered users and 3 guests |
|
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot post attachments in this forum
|
|
 |
|