Append Query creating multiple entrys!!!!!

[trackmedic]

HELP,

I need to append information from one address table to another address table. I built an append query and ran it the first time. It worked great. What I want to do is whewn I put a new address in table one, I want it to append the new information into table 2. What its doing is creating multple entries. Such as, if I have five entries in table one and append it 1 time it makes five, append it twice and it makes ten. What am I missing or is there an easier way to do this.

PLEASE hELP!!!!! MY BOSS IS ON MY BUTt!!!

 

[Rich]

Have to ask why you need two tables with the same information in each?

 

[trackmedic]

OK, Lets see if I can explain this. I have a form call material transfer. On this form, I have a ship from and ship to entry point. I have made these into combo boxes that pull a companies name from the address table. Like this it works great. I made the form off of a query. Well I now want to show the respective mailing addresses for the two companies on the form. The querie I made up for the form will not let me pull the additional information into it.

Basically I want to fill in two address areas on the same form with different addresses from the same table.

Makes any sense????