We have a database setup to display the results of an analysis for brokers. (Thanks JPDeni for your excellent help on the averages).
The database is accessed via a link from the main site. When a broker click on a link on the analysis page, it basically searches his record only to modify/view using the ID field, which is also his username on the main site.
What we would like is to be able to have everything below accessed from the same link on the main site.
When clicking on the link on the main site, wholesalers and administrators would be taken to a list view (via long/short mod) where they would choose the broker's record they want to view.
Is this possible, or do we need a different link on the main site.
Your thoughts?
Thanks
Buddy
The database is accessed via a link from the main site. When a broker click on a link on the analysis page, it basically searches his record only to modify/view using the ID field, which is also his username on the main site.
- All broker records are created in DBman for them.
- All ID' s for Administrators, Wholesalers and Brokers are created for them.
- There is no authentication so a broker clicks on his link and is taken directly to his record without login.
What we would like is to be able to have everything below accessed from the same link on the main site.
- A broker can view/modify only his own record (We have this working already)
- A wholesaler can view only the brokers with his ID in the WID field.
- An administrator can view everyone.
When clicking on the link on the main site, wholesalers and administrators would be taken to a list view (via long/short mod) where they would choose the broker's record they want to view.
Is this possible, or do we need a different link on the main site.
Your thoughts?
Thanks
Buddy