One field populates based on another field

[jhiltabidel]

TABLE field populated by contents of another TABLE field

Just for sake of example, I have a table with 2 columns in it. The first one is called "Hardware" and the second one is called "HardwareID". I do not wish either to be an autonumber. The data in each field is retrieved from another table called "Components" through a drop down box. When you click on the Hardware box and choose "Mouse"... you then have to click on the HardwareID field drop down and choose "1". I would like to be able to choose Mouse and then "1" populates automatically in the HardwareID box.

The first drop down box actually shows two columns in it... the hardwareID and the hardware. Can I make the second part of the column "jump" over to the next field and stay there ??

Mouse=1
Keyboard=2
etc.

Any ideas? MUCH THANKS IN ADVANCE!

 

[Friday]

do a search on this forum for "Cascading Combo Boxes" and you will find what you are looking for. Several examples have been posted over the years.

 

[jhiltabidel]

Data in one field autopopulates another record

I see plenty of references to forms using this method... which I already have setup on a form... one combo populates the records shown in another combo that you can choose. But I don't see any references that explain how filling in a field in a table pushes one column into the next field. Can you shed some light on that?

Like in Excel how you can put "=A4" in Cell A5 ... not sure if even I know what I am talking about... not sure how to explain

Thanks again,

Joe

 

[jhiltabidel]

Table only - not a form

On a form, yes. I don't see any drop downs in your tables. I'm not having any issues with this on a form. I don't know that what I'm looking for is a "Cascaded Combo".

Does anyone know if it's even possible STRICTLY in a table?

I appreciate the help.

Joe

 

[jhiltabidel]

Attached is the database.

Attached is the database. Create a new record. Choose something from the hardwareID field - notice it shows 2 columns. When you make a selection from the hardwareID field, I would like the second column (which is a description) to jump into the next field. All of the items you see listed right now in that table were manually entered. And for each selection in the hardwareID column, someone had to select it's match from the next column over.