BlackOut????

[Henrootje]

I have two tables

tblROVW
tblROMR

Both contain 2 identical fields; NUMBER CODE
in tblROMR both fields are filled, in tblROVW only the field NUMBER is
filled.

for example

tblROMR tblROVW

Number Code Number Code
1234567 311 1234567 {nothing}
1897546 547 1897546 {nothing}

Now how can I 'copy' the value of the field CODE from tblROMR to
tblROVW where Number should be equal?

I have been thinking about this for days, I know the solution is so
simple but it simply will not come to me :(

(I want the value actually entered in the tblROVW, that means not using
a select query)

TIA!

[Henrootje]

Never mind!

I had a momentary bright moment!!

UPDATE tblQROMR INNER JOIN tblQROVW1 ON tblQROMR.ROMR_NUIMBER=
tblQROVW1.NUMBERSET tblQROVW1.ROVW_CODE= [tblQROMR1]![code];

That did the trick!

[DFS]

Henrootje wrote:

I have two tables

tblROVW
tblROMR

Both contain 2 identical fields; NUMBER CODE
in tblROMR both fields are filled, in tblROVW only the field NUMBER is
filled.

for example

tblROMR tblROVW

Number Code Number Code
1234567 311 1234567 {nothing}
1897546 547 1897546 {nothing}

Now how can I 'copy' the value of the field CODE from tblROMR to
tblROVW where Number should be equal?

I have been thinking about this for days, I know the solution is so
simple but it simply will not come to me :(
Henrootje,

Some honest advice: if you really found yourself thinking about this issue
for days, you need to read up on SQL and relational databases, or ask for
help earlier.

Hints: don't name the field Number. That's an Access datatype (and a VBA
property) that may cause you problems. How about ID? And rather than Code,
you may want description_code.

So, maybe StatusID and StatusCode, or UserNbr and UserCd. Depends on what's
in the table.


(I want the value actually entered in the tblROVW, that means not
using a select query)

TIA!

[Henrootje]

Thanks for your advice DFS.
But I think this was typically a case of 'black-out' because in a flash
it came to me. It is as a name that is on the tip of your tongue......
You do know it but simply can not get iot to front :p

And 'Number' and 'Code' are not the actual fieldnames. But, since they
are dutch names here, I thought it would be easier to translate them
for people here.
The namingconvention as we use here for fieldnames is always
tabelname_fieldname
So the actual fields are ROMR_BankrekNr and ROMR_GeldRek (ROVW_ for the
other tbl.
All tablenames start with 'tbl', 'qry' for query etc

[Henrootje]

Thanks for your advice DFS.
But I think this was typically a case of 'black-out' because in a flash
it came to me. It is as a name that is on the tip of your tongue......
You do know it but simply can not get iot to front :p

And 'Number' and 'Code' are not the actual fieldnames. But, since they
are dutch names here, I thought it would be easier to translate them
for people here.
The namingconvention as we use here for fieldnames is always
tabelname_fieldname
So the actual fields are ROMR_BankrekNr and ROMR_GeldRek (ROVW_ for the
other tbl.
All tablenames start with 'tbl', 'qry' for query etc