Problems with linking fields on a form

[Mitt1]

Okay so this will be kinda hard to explain but I'll try anyway.

I am making a form for my customers to order products and on it they need their own address and their shipping address i.e the address they want to their products to be delivered from. Their owen address is stored on tblCustomer and their shipping address is stored on tblShip (figured it would be easier to make a separate table). On tblShip their is a relationship for the customer ID that when selected should pick the correct shipping address but on the form for some reason it changes the customer's own address and not their shipping address. Thanks for the help.

 

[AccessBlaster]

I attached a screen shot from Northwind sample db. Hopefully this is close to what you are trying to do.

If not post a screen shot of your relationship window.