Get value from another table

[uresan]

Hello all,
is it possible to create table where you write ID and field gets filled with value from another table.
See photo attached.
I'd like to have following automation. When I write ID in "Tabela2" I want field "tel" in "Tabela2" to be filled with value from field "tel" from "Tabela1" with same ID. Can this be done? If yes, how can I do that.
Thank you in advance.
Best regards,

[Bob Fitz]

It may be possible to do something like that while using forms but you would usually just display the data from the first table.

Can you tell us more about what you are trying to do and why you feel the need to copy the data to another table.

[ArviLaanemets]

This is really bad idea! An example why: Lets assume the some info about Janek Novak's phone number (ID = 1 in 1st table) was changed later. In another table(s), the previously entered phone numbers remain unchanged, and aren't valid anymore - you have to edit all tables containing phone numbers to correct the info about this phone number.

When you store only phone number ID in any other tables except phone numbers table, and get all phone number info in forms/reports using this/those table(s) as source calculated only (using functions or queries getting info from phone numbers table), then any change in phone numbers table will be immediately available everywhere in your database. No additional edditing of other tables is needed!

[uresan]

For instance:

1. I'd like to have table of articles (article ID and article Name)
2. I'd like to have table of orders with article details (order ID, article ID, article Name), where I'd write article ID and article name will be filled automatically.
3. When I edit article name in table of article I'd also like to article name gets updated in table of orders with article details

[ArviLaanemets]

And again, don't have article name in order's table - this will be a path to disaster! Article ID is all you need - the name can be calculated at any moment it will be needed.

It looks like you are planning to work with tables directly. I don't advice this! The best practice will be to work with tables only when you create them. After that you better hide them from any users (yourself included), and use forms to edit data, add new data or delete it. Forms are much better at data handling - e.g. in Orders form you can easily have a combo box linked to article id, which displays article name instead.

[uresan]

I'd like to have it on table at form. See photo attached. So when user will write article ID, article name will be displayed. That is also enough.

[Bob Fitz]

Is the picture that you posted a main form with a sub form, representing a one to many relationship between two related tables?

[orange]

Please describe what you are trying to accomplish in simple terms. If English is not you language,then write a description in your own language and then using Google translate, convert your description to English and post in the thread.

Prosim, opišite, kaj poskušate doseči na preprost način. Če angleščina ni vaš jezik, potem napišite opis v svojem jeziku in nato z Googlovim prevajalnikom pretvorite svoj opis v angleščino in objavite v temi.