How to link a table with multiple columns to another table

[qj15]

I have an Access Database for inventory tracking. I have a task list where someone could request a part by typing in their name/due date/part number etc...

I have created a table with the part numbers and their corresponding description. The task list I have already has a part number drop down box so users can select the part they need, however I want the corresponding part description to come up to on the task list for additional accuracy.

How can I link these two tables together so that when a user selects a part number on the task list that the correct description comes up to?

[twinnyfo]

qj15,

Welcome to Bytes!

The easiest way to do this is to change the RecordSource for your Combo Box. Create a query that joins the two tables, providing for the Part Number and the Descsription.

Without having any additional information on your two tables, we can't provide any more detailed responses. However, this seems to be the direction you would go.

[PhilOfWalton]

I would (at my peril) disagree with twinnyfo.

Set up the Combo Box (Let's call it CboParts) with 3 columns and the underlying query something like

SELECT PartID, PartNo, PartDescription FROM TblParts ORDER BY PartNo
 

Column widths (Metric) 0,2,5. - Play with this till it is right.
Bound Column is Column 1

Then create a text box with text box with the ControlSource

= CboParts.Column(3)
 

Note you do need the equals sign at the beginning of the ControlSource.

So Column(1) is the PartID, Column(2) is the PartNo, and Column(3) is the part description.

Phil

[twinnyfo]

@Phil,

Not disagreeing with you here. But, your solution is exactly what I described. OP makes it sound as if the Part and additional description are in two tables....

;-)