Populate Field in Table with Combo box within same table

S

Scott H

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.
 
J

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Link a text box based on drop down box with four options MS Word 365 0
Creating a Search using a combo box and then creating a report. 4
Populate a table based on check box status 2
Combo or list box 0
Dynamic Naming of Form Button 3
Re-Seed in SQL Server 11
Table/Forms Field Population 6
Finding the right style field in VBA 0

Top