Deleating Data

[Wiz Bang Computers]

I have two databases linked on account number. Table 1 stores payments and Table 2 stores address information for the customer.

I am having a problem with some of the fields being deleted in Table 2 when a payment record is entered into Table 1.

Some Table 2 data should appear on Table 1 once the record is committed though iwp, but I am only getting the customers name to appear and the rest of the data is deleted that I am wanting to appear on the form for Table 1.

Any ideas why this is happending?

Thanks,

Scott