EeID in TblContact is not a Primary Key, and it's not required and not indexed.
I've added a ContactID that is a Primary Key in TblContact, but that doesn't change the error messages.
Alma
Hello Bill,
That is the query/recordsource I have started off with.
I've since tried:
Main form - query TblEmployee and TblContact
Sub form - TblContact table only
This resulted in the Link Child Fields and Link Master Fields being the same (yea!!) - EeID - but a new error came up...
I've only been using Access for a week or two and have come across a frustrating problem... The description below is a simplified version of the tables and form/subforms, but essentially demonstrate the problem. Sorry for the long post!
I have 2 tables linked by a 1:many relationship and am...
Thanks for the suggestion. Unfortunately, we're not able to use Visio (lack of resources), so I guess I'm stuck with inputting/updating data in both Access and Powerpoint.
Alma
I'm a new Access user and am setting up a db with employee information.
Is it possible to pull information such as employee name and title, and manager name and title from an Access db into a report that looks like an organizational chart?
Your help is appreciated!
Alma
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.