Update table field by content in another field in the same table

[ADB_Seeker]

My table has OriginatorID and Originator fields. I want the OriginatorID
field to update automatically when content is entered in the Originator field.

The table that contains the data for these fields is called ASSIGNEES. It
has three fields: ID (primary key-autonum), ASSIGN-NAMES (text), and
EMAILADDRESS (text).
Originator ID in the table is the same as ID in the ASSIGNEES table.
ASSIGN-NAMES is the content for Originator field .
Thank you in advance for yuor assistance.
Linda

 

[techrat]

I am not 100% sure that I understand what you are attempting to
achieve however, I will give you some feedback based on what I can
gather from your post.
Essentially it sounds like you have an Assignees table that lists the
name and email of people. You also have a related table that you want
to relate records to a specific person (Originator?).

The way this is typically done is that the Assignee_id only (Not the
name also) will be stored in the related table as a foreign key to the
assignee table. This will allow you to display any of the person's
(Assignee's) information when working with the related table by way of
joining the 2 tables in a query or combo-box or directly through Sql.

Typically on a data entry form for the record containing the
originator field, you would have a combo box that display's the
Assignee/Originator name and when the name is selected, the
appropriate Assignee_Id is stored in your record.

It sounds like you are close.

HTH

 

[ADB_Seeker]

Thank you. Your post got me going in the right direction.