deliveries

[Guest]

i have a deliveries database. It is programmed so that it automatically pulls
up the shipping address from another form (a projects form). The projects
form has the job # and the site shipping address. Sometimes things are
shipped to a different address but still needs to be tracked to that job.
Right now if we need to change the address and we change it in that job # it
changes it in the projects form and thus in every delivery list that has that
job number. So what has to be done to a job (eg. 5089) we need to make a new
Job # 5089A. I want to be able to change the delivery address without having
it mess up all the other ones of that job#. Can i do this and how?

 

[Guest]

You need to give us some information about your tables. Where is the address
held in the tables and how are the tables related to each other? The
important thing is how the data is stored not how it looks on a form. Once
you have your tables set up correctly it will become easy to get the right
data on the forms.

Dorian

 

[John Vinson]

i have a deliveries database. It is programmed so that it automatically pulls
up the shipping address from another form (a projects form). The projects
form has the job # and the site shipping address. Sometimes things are
shipped to a different address but still needs to be tracked to that job.
Right now if we need to change the address and we change it in that job # it
changes it in the projects form and thus in every delivery list that has that
job number. So what has to be done to a job (eg. 5089) we need to make a new
Job # 5089A. I want to be able to change the delivery address without having
it mess up all the other ones of that job#. Can i do this and how?

You will need to add the necessary Address fields *to the delivery
table*. It's not redundant, because the Project address is in fact
sometimes different from the Shipping address.

Your form can pull the Project address from the jobs table, and "push"
it into the delivery table address fields as a default - but you will
need the fields in both tables.

John W. Vinson[MVP]