Lookup Help

[Toby Gallier]

Hi!

Here is the situation I have. I have a form with drop downs based on
each other so a "type" and "subtype". So the vaules of the "subtype"
are based on the "type" So to drive this i have two tables
"tblIssueType" and and "tblIssue" "tblIssuetype" holds the different
"type" values, two colums with the type id and type name . "tblIssue"
holds the different issues which references the "tblIssueType" table.
So it has the issue id, type id, and subtype name. the type id column
looks up the type id in "tblIssueType" and displays the name. When the
form is submitted it records the issue id to a third table
"tblOccurence" I want to have the issue id look up the type and subtype
on the two different tables and display as [type name - subtype name]
However, since the type name on the "tblIssue" is a look up from
"tblIssueType" when I try to get it to work i get [ Type id - SubType
Name] instead of having it carry over the type name.

Any ideas?

Thanks!