I have a table that contains these fields: ID, JobNumber, Title, Date. I want to make a combo box for JobNumber so that I can choose a value for JobNumber, and have the other fields on the form autopopulate with information from the table. I'm sure this is really obvious and I'm just missing it.
I am building a form that combines data from several tables. One table, Jobs, contains information about projects (like job #, budget, and so forth). That table is linked to another table, Contacts, that contains information about individual clients, via the ContactID #. I want to be able to...