T
Trish
I have two tables. Main table has primary key, surname, firstname, plus some other stuff. Data table has a look up field to get the surname and firstname, plus a primary key (because duplicates are allowed). When trying to select the name in the Data table, it shows only the number. This is understandable, as the look up field has defaulted to a numeric data type. I want to both see and display just the surname and firstname. What am I doing wrong please? The bound colums = 1, the column count = 3 (0cm;2.54cm;2.54cm). Have fiddled around with these to no avail. Would be very grateful for your help. Thanks.