LOOkUP DATA FROM SEVERAL FIELDS

[Guest]

Hello to all access users.

Here is my question. I' m novice to intermediate user, no script or litle
script skils.

I have this table, fields:
Local; N1; N2; N3; NCC.
I want to have a list box to select local and populate a field adress in
other table.
This I can do.
But I want has I do this to populate other fields in the same destiny table
whith fields N# and NCC.
How can I do This.

Please help.

Greatings from Portugal
AlípioSequeira

 

[Amy Blankenship]

Hello to all access users.

Here is my question. I' m novice to intermediate user, no script or litle
script skils.

I have this table, fields:
Local; N1; N2; N3; NCC.
I want to have a list box to select local and populate a field adress in
other table.
This I can do.
But I want has I do this to populate other fields in the same destiny
table
whith fields N# and NCC.
How can I do This.

You shouldn't do this. Store the data once and only once, and refer to it
in the other table.

So, if you add RecordID to "this table" (whatever that is), then when you
select a row from it with your list box, the RecordID will be inserted into
your other table. You can then join the two tables when you need to look at
the data from the Local, N1, N2, N3, and NCC fields together with whatever
is in that other table. The fact that you have N1-N3 fields also suggests
that maybe those fields should not be fields, but should be child records
related to "this table" as well.

HTH;

Amy

 

[Guest]

Hello Amy.

Thanks for helping me on this.
I'm developing a access DB for managing training courses for companies
workers.
The table "this table" is ment to store some codes Portuguese Government has
to Identify our different citys and vilages, as to their location. Therse
codes are Refered as N1 N2 N3 and NCC, go figure.

So what I understood from your post is I should create a relation between
the two tables, and get a query to join the fields I reffered as N3 and NCC.
Sorry for missing the obvious, sometimes one does not see the simples way to
do things. Thanks.
Gone to work on this.

Greatings from Portugal
AlípioSequeira.

PS: your "magnolia" web page is only what I visited at
www.magnoliamultimedia.com?

 

[Guest]

Hello again Amy.

Done your instructions. Working good.

 

[Amy Blankenship]