<div>
<blockquote>
So my question is how do I set this up so I can pick a PID and the Name fill in automatically? 
</blockquote>
<br />
how do you want to do this? in a form, create a combo box with rowsource from table PID, then use the afterupdate event of the combo to fill the other controls.<br />
<br />
describe the other tables purposes in this db, so we can give advice about the relationships needed.
</div>


<div>
There is no way for us to help you with the relationships if we do not know what is in the tables (or if they are properly normalized)<br />
<br />
For example, ...you say:<br />

<blockquote>
Info table will have employee name
</blockquote>
So why is the table named &quot;Info&quot;, ...instead of &quot;Employees&quot;<br />
What is the purpose of this Info table?<br />
<br />
You also say:<br />

<blockquote>
PIDs table will have employee PID, First name and Last name
</blockquote>
What does PID stand for?<br />
Why aren't all of these fields in the same table?<br />
&nbsp;employee name<br />
&nbsp;employee PID<br />
First name<br />
Last name<br />
<br />
PID is commonly referenced as a &quot;Field name&quot;, not a table name.<br />
So here before we ever talk about &quot;Relationships&quot;, ...we need to make sure that your tables are properly &quot;Normalized&quot;, ...<br />
<br />
So can you take a step back and explain to us what the purpose of this database is?<br />
And also state what &nbsp;data you want the tables to keep track of?<br />
<br />
As a start, let's clean up the Employee table:<br />
<br />
Table Name: tblEmployees<br />
Fields:<br />
eID (Primary Key)<br />
eFistName<br />
eLastName<br />
<br />
<br />
JeffCoachman
</div>


<div>
PID is the employee company ID.<br />
The DB is to track the loaning out of tools.<br />
I will need a form which individuals will fill out (paper or online) when taking the tools and then use the same form as a reference when returning the tools. So they will know what they took and what they need to return.<br />
I will also need reports to track what been loaned out, by who, when they took it, when they will return, conditions, etc..<br />
<br />
See attachment<br />
<a href="https://filedb.experts-exchange.com/incoming/2017/05_w18/1159771/Tools-List.accdb" target="_blank" class="file-inline" title="sample tools (680 KB)"><svg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 512 512"><path d="M67.508 468.467c-58.005-58.013-58.016-151.92 0-209.943l225.011-225.04c44.643-44.645 117.279-44.645 161.92 0 44.743 44.749 44.753 117.186 0 161.944l-189.465 189.49c-31.41 31.413-82.518 31.412-113.926.001-31.479-31.482-31.49-82.453 0-113.944L311.51 110.491c4.687-4.687 12.286-4.687 16.972 0l16.967 16.971c4.685 4.686 4.685 12.283 0 16.969L184.983 304.917c-12.724 12.724-12.73 33.328 0 46.058 12.696 12.697 33.356 12.699 46.054-.001l189.465-189.489c25.987-25.989 25.994-68.06.001-94.056-25.931-25.934-68.119-25.932-94.049 0l-225.01 225.039c-39.249 39.252-39.258 102.795-.001 142.057 39.285 39.29 102.885 39.287 142.162-.028A739446.174 739446.174 0 0 1 439.497 238.49c4.686-4.687 12.282-4.684 16.969.004l16.967 16.971c4.685 4.686 4.689 12.279.004 16.965a755654.128 755654.128 0 0 0-195.881 195.996c-58.034 58.092-152.004 58.093-210.048.041z"/></svg>Tools-List.accdb</a>
</div>


Tools-List.accdb

<div>
I was hoping for some dialog on how to build my own not buy someone else's db. These are only free to look at you can't really get into them to see and understand how the relationships, queries and tables are built.
</div>


<div>
the link I posted is just to show you the forms of the db. you DON&quot;T have to buy it.<br />
as I said above it is FREE, <br />
----open access application then click on Assets and select Lending library<br />
&nbsp; &nbsp; &nbsp; &nbsp; from here you can download the template from Microsoft<br />
&nbsp; &nbsp; &nbsp; &nbsp; you can also view the relationship on this template
</div>


<div>
Thanks<br />
Play around with this design (create the relationships)<br />
and add a few records, ...it all should work without forms, ...when you verify that the design is sound, ...thne you can post Questions about the forms and reports<br />
;-)<br />
<br />
Jeff
</div>


<div>
<div class="content wysiwyg-content">
I am creating a new db and I need some advice and direction on the relationships<br />
<br />
Tables:<br />
Info<br />
PIDs<br />
Plants<br />
Tools<br />
<br />
Info table will have employee name<br />
PIDs table will have employee PID, First name and Last name<br />
So my question is how do I set this up so I can pick a PID and the Name fill in automatically?
</div>
</div>


I am creating a new db and I need some advice and direction on the relationships

Tables:
Info
PIDs
Plants
Tools

Info table will have employee name
PIDs table will have employee PID, First name and Last name
So my question is how do I set this up so I can pick a PID and the Name fill in automatically?

Access creating new db - relationships

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.