|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
June 30th, 2008, 09:51 AM
posted to microsoft.public.access.queries
|
|||
|
|||
help with a query
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 
|
|
#2
June 30th, 2008, 03:35 PM
posted to microsoft.public.access.queries
|
|||
|
|||
|
help with a query
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. -- KARL DEWEY Build a little - Test a little "Nuno Gomes" wrote: 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
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
