Populate Field in Table with Combo box within same table

[Guest]

I have two tables,

Table1
JobCode (text field)
JobDescription (text field)
JobFamilyNumber (Number)
JobFamilyName (Text)

Table2
JobFamilyNumber (Number)
JobFamilyName (Text)

I want to be able to use a drop down box in Table1 to select JobFamilyNumber
taken from Table2 and have JobFamilyName automatically populate based on the
JobFamilyNumber from Table2.

I am ultimately trying to create a master table that the rest of my database
is designed off of.

Thanks in advance.

 

[Jeff Boyce]

Scott

"Step away from the computer..."

If you scan this newsgroup (tablesdbdesign), you'll find a strong consensus
against using "lookup" data types, and against working directly in the
tables.

Access tables store data, Access forms display data.

Create a form (or main-form/subform) to do what you're describing.

Regards

Jeff Boyce
Microsoft Office/Access MVP