Creating Forms and linking to Other Tables

D

Daniel9684

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
 
P

Penguin

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.
 
D

Daniel9684

I'm a bit lost

I think I'll need a step by step thing here, can anyone help with this?
 
Top