Showing value for menulist instead of ID?
Ive built a set of dataassit wizard pages. I have 2 tables in my database, one for items and one for itemstypes. In my items table I have a foreign key field (itemtypeID) linking the itemtype table with the main item tabel. So far so good.
On the wizard insertpage I have formatted the linked itemtypeID field to show a menulist of the values from the itemtype table. This works good and I can choose value (itemtype) and its inserted correctly in database. Its ID is inserted in the foreign key field (itemtypeID) in the items table.
On the Results and Details pages from the wizard I would like to show the value for that field instead of the ID!? How can I accomplish this? Probably very simple but I'm new to this!
Hope somebody has a simple explanation! ;=)