This thread looks to be a little on the old side and therefore may no longer be relevant. Please see if there is a newer thread on the subject and ensure you're using the most recent build of any software if your question regards a particular product.
This thread has been locked and is no longer accepting new posts, if you have a question regarding this topic please email us at support@mindscape.co.nz
|
OK, so I am trying to load a dropdownlist datasource with the results of a query between two tables. I cannot figure out the exact means to do so. Table A is a list of roles - rolekey, rolename. Table B is a list of users with the role - userkey, rolekey, notes; Any entry in B must have a rolekey from A - in other words, foreign key. I want a list of rolekey, rolename where the entries are from B for a given userkey. The sql I want looks like: SELECT b.USERKEY, b.ROLEKEY, a.ROLENAME from USERS_ROLES b inner join ROLES a on b.ROLEKEY = a.ROLEKEY which I then want to filter for specific USERKEY values and set that list into the datasource for the dropdown list/grid/whatever. A bit of guidance would be greatly appreciated. |
|
|
|
