I have a value list that gets its values from the Name field in the Clients table. In the Clients table, there is also a field Client Number. In a different table, I have a drop down box where the user can select a Name. What I'd like is to have the Client Number for that Name appear in a field in this second table. Do I have to relate these two tables to get this to work or is there another way?

Thanks!

The easiest way I know is to relate the tables. Although I would recommend using the Client Number for the relationship instead of the Name. Client numbers can be unique, names are not always. For the drop down list, you can use the Client Id field. Set the value list to show the Client ID and click "also display values from second field". the second field would be the name. Then click on sort values using second field. Then your name field can be a lookup or auto enter calc and both fields will be populated.