I have, multiple tables,
division,
department,
group,
user
each of these have name and id
in another table(usergroupings) i have
userID
groupID
divisionID
departmentID
which are all foreign keys to the primary tables
this links a user id to a division department and group
now using Linq, i want to be able to populate,
a combo box with the group name etc,
and insert the id into(usergroupings)
I can see the relationed tables in (usergroupings),
but it does not populate the combo box with the values.
dbs = new dbConnDataContext();
var userGrouping =
from c in dbs.UserGroupings
select c;