Combo box problems

[jk42]

Hi!

Question: I have Form Project Details that I made for data entry. I based it off of a query that I made off of TblProject Details. TblClientDetails has a one to many relationship with TblProjectDetails (based off of an PK of a name and ID).

My question is this: When I view the form in datasheet view and enter information into the FKClientID and FKClientName boxes, it works just fine. When I try to get all fancy and make a combo box on that form for those same two boxes, it tells me that I cant add or change a record because a related field is required in TblClientDetails. WHY is this happening?! And why isn't it happening in datasheet view? I don't understand at all, because I am simply picking from a list that I based off of TblClientdetails! In addition, if I go to Tblprojectdetails and enter it in there, it becomes fine again. Any explanation would be helpful. What I googled yesterday did not answer my questions at all.

Thanks!

 

[boblarson]

It sounds like you either have more than one table in your form's record source, which normally should not be the case. Or you have a field in your table that has a lookup assigned directly at table level, which I would avoid to keep from having issues like shown here:

http://www.mvps.org/access/lookupfields.htm

 

[jk42]

Thanks. I'll check it out. I shouldn't have any look up tables, I have read that article so many times! But I'll double check. Side note: I was reading an Access book when I first started this process, and the only mention of look up tables causing problems was a TINY paragraph on the top, and they did not even make it sound like it was even that big of a deal. Wish they had-would have saved me a lot of time!

 

[jk42]

Hi Boblarson,

Just wanted to give you an update. I made it work. I made one combo box where I just put the Client ID, and then a completely separate box for the Client name, and obviously they have to match table that I got them from. That seemed to satisfy the problem!

Thanks!