R
Robbie
I have three ODBC linked tables, each has a field called LDKEY that contains
the primary key for memo text on the third table called LONGDESCRIPTION. The
problem is, two LDKEY fields are stored as number and one is stored as text.
I am told the system tables have these field types set as number but somehow
Access converts some of the field types to text when transfered over. Can I
still use the existing fields and types to query for matches and retrieve the
LONGDESCRIPTION text.
the primary key for memo text on the third table called LONGDESCRIPTION. The
problem is, two LDKEY fields are stored as number and one is stored as text.
I am told the system tables have these field types set as number but somehow
Access converts some of the field types to text when transfered over. Can I
still use the existing fields and types to query for matches and retrieve the
LONGDESCRIPTION text.