Dataviews and joining to tables

[Brian Henry]

I have a strange problem...

I have a junction table that i need to filter based on a id, then take the
filtered data and join it to a description table then show the data that was
filtered in a listbox with the description instead of the id... here's an
example
Junction table
============
EntryID int
ItemID int
DescriptionTable
=============
ItemID int
Name varchar(100)
now a person has an entry which has many items in the junciton... i need to
filter the junction table based on the entryID so i have a list of all the
items a person has, then show that in a list box... but instead of showing
the ItemID... I need to show the name of the item from the description
table... how would I do that? Dataviews seem to work just for filtering the
junction table and returning the ItemID only but i really need that
description, its a lot more descriptive then some arbitrary ID number on the
screen

[Jay B. Harlow [MVP - Outlook]]

Brian,
There is a JoinView sample custom DaveView class for VB.NET that may do what
you want.

See:
http://support.microsoft.com/default...en-us%3B325682

Hope this helps
Jay
"Brian Henry" <brianiup[nospam]@adelphia.net> wrote in message
news:Op**************@TK2MSFTNGP09.phx.gbl...

I have a strange problem...

I have a junction table that i need to filter based on a id, then take the
filtered data and join it to a description table then show the data that was filtered in a listbox with the description instead of the id... here's an
example
Junction table
============
EntryID int
ItemID int
DescriptionTable
=============
ItemID int
Name varchar(100)
now a person has an entry which has many items in the junciton... i need to filter the junction table based on the entryID so i have a list of all the
items a person has, then show that in a list box... but instead of showing
the ItemID... I need to show the name of the item from the description
table... how would I do that? Dataviews seem to work just for filtering the junction table and returning the ItemID only but i really need that
description, its a lot more descriptive then some arbitrary ID number on the screen