I have a query based on two related tabels in an Access database. I
have added commands in the dataenvironment for both the tables and the
query. I made the query as an SQL statement. The structure of the
database is like this:
Format '(Hardback or paperbback)
(and some other fields related to the title)
In the query I have both the EditorID (from tableTitle) and EditorName
(from table Editor) and both of them are on a form I will use for
searching records (by title) and also adding, editing and deleting
Now, if I add a record and fill the editorname field and the editor
ID field, Ill have this errormessage:
"The field Editor.EditorID cant contain a Null value because the
required property for this field is set to True. Enter a value in this
Then if I dont fill the editorname field but only the editorID field
it works okey and the record is added.
How I want it to work is like this: I want to pick the editorname from
a combobox and have the editor ID filled in automatic (or not at all
if it is possible). There will be around 100 editors. The application
must function on a network. From learning reasons I would like to do
it without the datacontrol (and because everybody says its no good).
Someone who has some explanation to the "mystery" above and some hints
on how I make it the way I want it?