Creating Forms and linking to Other Tables

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am a new Access user and I have been desperately trying to get something to
work.

I have one table (tblSiteLibrary) with about 15 fields, and another
(tblClient) with just two fields. There is a common field, ClientID.

In tblClient, the fields are ClientID and Name. I want to be able to type
the ClientID (a number) into tblSiteLibrary and the Name appears on the form
instead of the ClientID

Can anyone help me with this???

Daniel
 
Try using a query for your forms Record Source instead of a table.
Creating a simple query from both tables and is linked via ClientID.
Select all fields from tblSiteLibrary and only the Name field from
tblClient. When you select a ClientID the Name field should be auto
filled from your tblClient.

Hope this helps.
 
Back
Top