Store the Value of the Combo Box - Microsoft Access Expert 1


	Back to Access Expert 1 Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Store the Value of the Combo Box

Thorsten Wiedemann

45 days ago

Exp1 Lesson 4 13:15min

Hello.
You said: "store the value in the Customer ID field in the contact form" .
But does not ACCESS store that value from the Combo box (the Customer ID) in the Contact ID field in the Contact Table? And the Customer ID field in the form takes it from there? Otherwise this would no longer work when you delete the field a few minutes later.

Sorry for asking this. New to ACCESS. But paid so much money for lessons from you so that I thought I wonna be sure if I do think it the wrong way...

Thanks a ton from Bonn
Thorsten

Joe Holland @Reply

45 days ago

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.

	Alex Hedley @Reply 45 days ago
Relationships

	Thorsten Wiedemann OP @Reply 45 days ago
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!

	Joe Holland @Reply 44 days ago
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.

	Thorsten Wiedemann OP @Reply 43 days ago
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

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Expert 1.

Next Unseen

New Feature: Comment Live View