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" .....