Pull customers details from one table into into another on a form

[NN]

Hi,

I have a main table, tblJobs which have fields for addresses etc but I would
like to have a seperate table for customer details such as address etc
rather than retyping addresses when the same customer gives us a new job.

That way I can select what company on my main form (which is bound to
tblJobs), and then access pulls the address fields etc into tblJobs.

OR, is there an easier way without having to use a seperate table for
customers?

Thanks guys!...

Nick Jones

[pietlinden]

NN wrote:

Hi,

I have a main table, tblJobs which have fields for addresses etc but I would
like to have a seperate table for customer details such as address etc
rather than retyping addresses when the same customer gives us a new job.

That way I can select what company on my main form (which is bound to
tblJobs), and then access pulls the address fields etc into tblJobs.

OR, is there an easier way without having to use a seperate table for
customers?

Thanks guys!...

Nick Jones

Sounds like a bad design. Address belongs to customer. Why do you
need another table for Address? Does a customer have more than one?
What does an address have to do with a Job? Explain what you're trying
to model.