Dataviews and joining to tables

  • Thread starter Thread starter Brian Henry
  • Start date Start date
B

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
 
Back
Top