Stuart S
|
| Posted: 06/05/2003, 10:25 AM |
|
I am using codecharge 2.05 asp and access.
I have a grid like this.
name - position - email - city - phone
The grid contains records from different cities that I have listed in a seperate table.
e.g.
Cities Table
1 dallas
2 houston
3 austin
4 san antonio
What I would like is after somebody completes registration they login to see this grid but they will only see records for their city.
Upon registration the city name is stored in members table but the grid city name is linked to cities table.
So if meber city is Houston show only records for Houston
Thanks for any help
|
|
|
 |
rrodgers
|
| Posted: 06/06/2003, 10:31 AM |
|
You need to decide where you will get the city information about the logged in person from. Cookie, session, url etc. (I wouldn't use the url myself.)
Modify the login function to set a session or a cookie with the logged in user location.
Click on the grid. Click on the datasource. Go to the datasource properties. Add a line to the where list box that would only show the records that match the session or cookie value.
rob
|
|
|
|
|
