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
 
M

Maelinar

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