No. The CustomerID is not stored in the ContactID field of the contact table. The ContactID is a unique identifier for each record in the Contact table. The CustomerID is an identifier for which customer relates to each contact record. You need the ContactID and the CustomerID in the Contact table for the relationship to work. The combo box helps you more easily select the CustomerID for each contact record and stores it in the CustomerID field in the Contact table. Tables hold data and forms display the data.

Relationships

Hello,
in the video at that specific point:

He (not me! ) said: stores the value in the Customer Id field n the contact FORM.  

Anyway: thanks!

He did and it does. The combobox helps you select a customerID for the current contact record. This is saved in the customerID field of the contact table. The form is based on the Contact table.

Hello,
Sorry. But if it would do straight (like it sounds for me) the form would no longer work as soon as he deleted the field. So you gave me the answer I was looking for: it is stored in the table and the form field picks the information from the table.

Thanks