Update table fields from another table!

[voskouee]

I have a table that is static. it has listed the following things. let me call it table A

Table A
Code Rate Org
123 e rf
234 t rg
125 g lk


then i run a query for another table to get the working codes.. these that the only codes am going to use. but i want to get the codes and automatically update Table b with the other values

Table b
Code rate org
125 ????? ????
234 ????? ????


the missing data should be filled out automatically when the code is added to the table...

any ideas?

 

[neileg]

Either use an update query, or do it in a form bound to table b.

 

[voskouee]

I was using an update query but had the wrong criteria..

i corrected it and it works just fine..

thanks for the pointer!

 

[RuralGuy]

I looks like you might be breaking some normalization rules by storing the same data in more than one table.

 

[neileg]

Yeah, RG, I thought that. But I also thought that table a might be subject to change over time rather than being truly static (like a price table), in which case storing the data avoids the problems of later amendment.

 

[RuralGuy]

If it is for historical prices then that is one of the exceptions to the rules and perfectly acceptable. The comment was more for the OP than you Neil. I just couldn't resist putting in my $0.02 I guess. I need to work on that.