Hi - I have a list of Table A made using the wizard. Now I'd like to replace one of the columns in the list of Table with a record from a field in Table B. How do I create a recordset that will select from Table B using a field from table A as the ID? Or do I even need a recordset for this?
No - I mean that in my list page (not the form/detail page) I would like one of the columns to lookup the record and display a field from a different table, using the ID from the first table as the identifier of the record.