can't add new records

[hollis via AccessMonster.com]

I am creating a database questionaire for human resources. I have found
AccessMonster to be the most helpful for any "issues" as they occur,
following many of the links to obtain examples. After a couple hours of
research, I haven't yet found a solution for my current dilemma.

I have six tables - Departments, Associates, Questions, QuestCharc, Response,
Session.

I can add records to Dept, Assoc, Quest, and QuestCharc tables but I can no
longer add records to Resp or Sess tables (previously, I could). When I
couldn't find my problem, I deleted all queries and forms that referenced the
tables. But I am still unable to add new records to those two tables. Any
suggestions of where and what I need to look for?

 

[Roger Carlson]

What sort of error message are you getting? Are these native Access tables
or are they linked tables? Access or SQL Server or Oracle tables? Do these
tables participate in any Relationships with other tables?

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

 

[hollis via AccessMonster.com]

Thank you Roger for you quick response! I have inserted my answers to your
questions....

What sort of error message are you getting?

** No error messages...cursor/enter key just will not proceed further.

Are these native Access tables
** Yes

Do these tables participate in any Relationships with other tables?

**Yes, I built the tables, but did not use a lookup wizard instead I created
the relationships in the Relationship Window.

pk DeptID.Dept is related 1to1 EmpDept.Associate
pk EmpID.Associate is related 1toMany SessAccoc.Session
pk SessID.Session is related 1toMany SesID.Response
pk QuestResp.Questions is related 1toMany QuestResp.Response
pk QCID.QuestChar is related 1toMany QCID.Question

 

[Roger Carlson]

And you are trying to enter data directly into the tables? Not via a form
or query? Are you entering a valid Foreign Key value in the record?

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

 

[hollis via AccessMonster.com]

Thanks Roger though I have found the problem
..amazing what taking a break for lunch can do for the mind...
(It was a simple mistake related to a required field in my table structure..
duh)

 

[Judy]

What sort of error message are you getting? Are these native Access tables
or are they linked tables? Access or SQL Server or Oracle tables? Do these
tables participate in any Relationships with other tables?

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L