I have a table of items with pk item_id and 3 other attributes: item_description, from_item_id, to_item_id and main_item_id. The table is joined to itself so that from_item_id, to_item_id and main_item_id must exist in the item_id table.
I now want to fill an asp.net gridview with:
item_id, item_description, from_description, to_description
I've gone into the typed list designer added the item table 3 times but cannot make connections between item.item_id to item.from_item_id anditem.item_id to item_to_item_id
Am I doing something wrong ?
I'm trying to convince colleagues that llblgen is the way to go and this is a showstopper.
v1.0.2005.1 Final March 31st 2006