S
SnooziSuzi
Hi there,
I am not an advanced Access user so please speak slowly in giving your
response!
I am using MS Office 2007.
I have a linked table with my outlook contacts in Access
As an office administrator I need to set up meetings on behalf of other
people, and for this I have created a database so that I can run reports
easily to show who is expected, has given appologies etc.
I have two problems:
Firstly; not all of the fields that are used in the contacts are showing in
Access. This is not a major issue because I can work with what I have.
Secondly; as the table is linked I cannot add / there is no ID column so
that I can link the results else where.
How can I set up relationships between tables if there is no ID column to
link please? there are no single columns that contain unique information and
I can't change the use of an outlook column to do this as I am using all 4
User Fields for other data (because not all of the fields have come across
from outlook!!)
please be gentle
Su
I am not an advanced Access user so please speak slowly in giving your
response!
I am using MS Office 2007.
I have a linked table with my outlook contacts in Access
As an office administrator I need to set up meetings on behalf of other
people, and for this I have created a database so that I can run reports
easily to show who is expected, has given appologies etc.
I have two problems:
Firstly; not all of the fields that are used in the contacts are showing in
Access. This is not a major issue because I can work with what I have.
Secondly; as the table is linked I cannot add / there is no ID column so
that I can link the results else where.
How can I set up relationships between tables if there is no ID column to
link please? there are no single columns that contain unique information and
I can't change the use of an outlook column to do this as I am using all 4
User Fields for other data (because not all of the fields have come across
from outlook!!)
please be gentle
Su