Retrieving Value in a table field via link to another table

[Tfrup12]

Hi,
I have two table linked together one is a Master Customer List the other is
a Special Orders table. I have set up a Lookup field in the Special Orders
table to allow me to get the CustomerID from the Master Customer List. I
would also like to have the CustomerName field populated at the same time,
based on the CustomerID link, from the Master Customer List in the Special
Orders table, for reference purposes. This seems so simple but its one of
those days...

TIA,
tfrup12

 

[Beetle]

There are a few issues to address here.

1) You should not be using lookup fields in your tables. See this link for
more on the subject.

http://www.mvps.org/access/lookupfields.htm

2) You should not have a CustomerName field in your Special Orders
Table, only the CustomerID as a foreign key.

3) You should not be working directly with the tables in the first place.
Tables are for storing data. You should be using Forms for data entry.
Your forms would (typically) have combo boxes for displaying data
from other tables. In your case it sounds like you would want a Main Form
/ Sub Form, where the Main Form displays the Customer info and the
Sub Form displays info about the Special orders.