By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,963 Members | 920 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,963 IT Pros & Developers. It's quick & easy.

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

P: n/a
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

Oct 24 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a

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.

Oct 25 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.