Displaying look-up values results page

Hi there, have just started using data-assist (i previously used Interakt then ADDT)

ive gone through the wizard to create all my pages which works as expected.

some of the colulmns are look-ups to other tables, so an id is stored in the relevent column.

On the inset and update pages i get to choose a recordset to populate a menu with the id(value) and name(displayname for the menu), the id is saved to the column.

on the results page in the table it displays the id.
Id's are not very helpfull to the user updating the information, is there a way i can display the name from the look-up table??

the addt was able to do this, i have looked through help and the forums but not been able to find an answer, i do hope this is possible.

thanks for your time.

You will need to edit the recordset on the results page to a joined recordset to return the information from the child tables, then replace the ID binding with the binding for the corresponding name column.


For more detail son joined queries, see the following page:
sql_join.asp

Thanks for the quick reply jason,

I was thinking i would have to do something like that.

you're welcome.