How do i link tables together?

S

sea_minerals

I've created a database for clients and jobs.

I have one table for Client. I have drop down menus listing the jobs.

Is there a way to have another table just for jobs so if i need to add
another job it updates the drop down menu's in everything and i just
have to create the reports?

At the moment if i have to add another job in, i have to redesign
everything - tables, forms - which can be a bit time consuming.

thanks
 
G

Guest

When you set up the jobs field in the clients table did you tell it to look
up fields in another table (jobs table) ?

Mæl.
 

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

Count ID from one table that matches another and show in a form... 2
Carrying a value between 2 tables 3
Increment a number based on instances in another table 1
how do you show all fields from linked data? only shows first one 1
Using Combo box to search from 6 columns? Is it possible? 10
Changing Primary Key numbering format 1
Calculate Sum and Write it to a Table 8
Summing groups in a report 1

Top