By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,268 Members | 1,309 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,268 IT Pros & Developers. It's quick & easy.

mutiple tables link in forms

P: 2
Hi, I am pretty new in ACCESS , however I am trying following :
Table typist has empl_id(key),name,last_name,
Table legal_debate has date,location,case_id,typist(id)
typist_id used as typist.empl_is

I made a subform on Table typist , using a single combobox with rowsource is :SELECT typist.employer_id, typist.first_name, typist.last_name FROM typist ORDER BY [first_name], [last_name];

In Main form I had linked_child_field=empl_id,link_master_field=typis t

When I browsing exstent records in table legal_debate , evrything seems OK , when I am trying to insert a new record to legal_debate.typist using combolist selection from subform
I am getting : You can't add or change a record bacause a related record is required in table typist" .....
May 30 '10 #1
Share this Question
Share on Google+
1 Reply

Expert 100+
P: 1,134
First question
on one of the existing legal_debate records, can you
1) change the typist with the combobox
2) navigate to another record
3) navigate back to the record you changed

and the typist has changed?
if you can that should indicate its all linked ok.

Next question
When you created the new record in legal_debate did you enter any values into the fields from that table?
Also try doing that and then navigating to another record and then come back to that new record and then select the typist. Does that work?

Its been a while since I have done any of this in access but I am thinking that the record
in the form hasn't actually been created in the legal_debate table yet.
Memory tells me the record gets created in the table when you navigate away from the record in the form.

Someone say something if my memory is faulty
May 31 '10 #2

Post your reply

Sign in to post your reply or Sign up for a free account.