An access database uses a combo box as the lookup display control for a foreign key, to get the 'Description' field from the linked table into the main table (bound column=1, column count=2,column width=0cm,3cm etc.)
I cannot link the tables in crystal because the field in the main table has the data type (string) of the 'Description' field in the in the linked table, but returns the bound column's value (from an autonumber field) for the foreign key? If I link using the foreign key (bound column value) to the primary key (autonumber), a file link warning due to different type is returned and no data. Any suggestions?
I cannot link the tables in crystal because the field in the main table has the data type (string) of the 'Description' field in the in the linked table, but returns the bound column's value (from an autonumber field) for the foreign key? If I link using the foreign key (bound column value) to the primary key (autonumber), a file link warning due to different type is returned and no data. Any suggestions?