J
Jamie
I have 2 tables in Access. One of these is linked to an Excel worksheet. I
would like to create a form that shows information from the Access Table and
3 fields from the Linked Access Table.
Primary Key is StudID in the Access Table.
There is also a double numerical field in the Excel worksheet (and the
linked Access table) that contains the same number.
When I tried to set a relationship for StudID, my only choices were
one-to-many of "indeterminate". (I've tried them all - although what I need
is a one-to-one relationship).
When I open the form, instead of the 8 records I expect to see, I get 80 (10
for each person).
Question is, can I have a form that contains info from the Access table and
the linked table?
Thank you - Jamie
would like to create a form that shows information from the Access Table and
3 fields from the Linked Access Table.
Primary Key is StudID in the Access Table.
There is also a double numerical field in the Excel worksheet (and the
linked Access table) that contains the same number.
When I tried to set a relationship for StudID, my only choices were
one-to-many of "indeterminate". (I've tried them all - although what I need
is a one-to-one relationship).
When I open the form, instead of the 8 records I expect to see, I get 80 (10
for each person).
Question is, can I have a form that contains info from the Access table and
the linked table?
Thank you - Jamie