table update

[texas1014]

Is there a way to have a field on a table updated based on the selection made on another field? I have two tables, the tblMasterItem and tblHW_SW. on the tblMasterItem table, I am able to use a combobox to make a selection. The combo box uses the information from tblHW_SW. when I make the selection from the combo box, I want the value from another column on that table to populate the information on the tblMasterItem table.

Example, on the HW_SW table, lets say my choices are:

Type Example______________
Hardware | Tower, Monitor
Software | Text Editing, Games
Options | Cases, Memory Upgrades



When I select Hardware from the combo box, I want the value "Tower, Monitor" to appear on the Example column.

I posted a similar thread on the query forum because I was thinking of using an update query, but I am wondering if this is a better solution.

Thanks,
Tex

[pbaldy]

You shouldn't store Example. See if this helps:

http://www.baldyweb.com/Autofill.htm

[texas1014]

Thanks for the document. I know how to do that for forms, but I am working directly with the tables; no forms have been created yet. Is there a way to do this on tables? If I am misunderstanding you, please forgive me.

[pbaldy]

Most of us never let users work in tables, and in any case no way to do it in a table. Normalization rules would say not to store that second value anyway, and I wouldn't do it. You get it in queries by joining the tables.

[texas1014]

Thanks. I didn't realize it was not a function at all.

Tex

[pbaldy]

No problem Tex.

[texas1014]

I created a form that looked like the table and added the code as an after update and it works on the form. Now I won't be driving myself nuts...