in access how to link addresses into another form

[Guest]

I need to know where to start to link an address book of customers into
another form to save typing in the address each time a regular customer
places an order. I believe there should be a way for access to automatically
save all addresses entered into a field and to recall them on entering a new
record. If anyone can point me in the right direction it would be greatly
appreciated.
many thanks in advance

 

[Guest]

This is all about good database design. If you are keeping addresses in an
order table, you should not. You should have a customer table that has ship
to and bill to addresses. Then in your order form, once you have selected a
customer, you should have code that finds the address for an existing
customer and loads it into your form for display. The order table should
then have a relationship to the customer table so you can retrieve the
addresses for printing and displaying as needed.

 

[Guest]

Many thanks, i think i get the jist of this. I was planning to build a table
to contain addresses but I am unsure as to how i would get the address to
display in the form once i have found it from the 2nd table. Will access be
able to do this relatively easily or will i need a lot of code and a big
headache? I only learnt access databases in the last two months but have
passed my level 3 exams, unfortunately it didn't cover this-typical hey! Any
help gratefully recieved