|
|
Our Hot Pick: Rising Antivirus 2006 - Certified by TUV & Checkmark! Get 10% discount by entering this coupon code: ONDISCOUNT10
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
|
|
|