in access how to link addresses into another form

  • Thread starter Thread starter Guest
  • Start date Start date
G

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