Creating Forms and linking to Other Tables

[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

 

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

 

[Guest]

I'm a bit lost

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