help with a query

N

Nuno Gomes

Hello all,

I have table Customer with the field CP
I have the table Cpostal with the field CP_NUM

The relation between this two tables is Customer.CP 1->N Cpostal.CP_NUM
This means that the for one CP code in the table Customer i have N CP_NUM in
the table Cpostal.

My goal is update the field CP with the first ocorrence of CP_NUM.

How can i do this?...



Thank's in advance,


Nuno Gomes
 
K

KARL DEWEY

My goal is update the field CP with the first ocorrence of CP_NUM
Based upon the information you presented it can not be done.

You say that CP is related to CP_NUM in a one to many. If they are related
then there is nothing to update as they are the same from the start.

Maybe you meant something else.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help with a query... 8
Union Query - Select Distinct 2 fields 7
MS Project Center-Autolink column fields 0
Reset a auto number field 3
Multi Value Selection issues 4
emp CP tables in report builder 6
Replace MS Access Error with Custom Error 4
Embed the same Excel multiple times 0

Top