C
Clair
Hi - I hope you can help.
I'm using Access 2003 Professional Edition - I've created a table linked to
an excel file.
I would like to create a relationship with the linked file (foriegn key) and
my customer table and display a subform of the linked Excel file.
When I create a foriegn key field and do a look up to the linked table from
the Table Design mode, Access tells me the relationship can not be created.
Is it important to have a primary key on the linked table - or I'm I missing
something bigger?
Clair Dorsey
I'm using Access 2003 Professional Edition - I've created a table linked to
an excel file.
I would like to create a relationship with the linked file (foriegn key) and
my customer table and display a subform of the linked Excel file.
When I create a foriegn key field and do a look up to the linked table from
the Table Design mode, Access tells me the relationship can not be created.
Is it important to have a primary key on the linked table - or I'm I missing
something bigger?
Clair Dorsey