423,311 Members | 1,224 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 423,311 IT Pros & Developers. It's quick & easy.

How to link a table with multiple columns to another table

P: 1
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?
Jul 11 '18 #1
Share this Question
Share on Google+
3 Replies


twinnyfo
Expert Mod 2.5K+
P: 2,532
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.
Jul 11 '18 #2

PhilOfWalton
Expert 100+
P: 1,290
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

Expand|Select|Wrap|Line Numbers
  1. SELECT PartID, PartNo, PartDescription FROM TblParts ORDER BY PartNo
  2.  
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
Expand|Select|Wrap|Line Numbers
  1. = CboParts.Column(3)
  2.  
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
Jul 11 '18 #3

twinnyfo
Expert Mod 2.5K+
P: 2,532
@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....

;-)
Jul 11 '18 #4

Post your reply

Sign in to post your reply or Sign up for a free account.