from neodbpro

#1 · August 24, 2022, 5:28 pm

Dear friend, I bother you because I know that you are the person with experience and an expert on these issues, you see I never made a relationship of tables with neodbpro.

I have a database called management
the base has two boards
1 table called owners
-- fields are: folder (this field is primary key)
surname
Names
direction
phone
e-mail

the second table is called properties
It has the following fields

Folder (primary key)
Property

I need to relate both tables so that when I look for the folder that is the common field, it shows me the data of table 1 and 2 but I cannot figure it out, I have read the example but the truth is that I cannot understand it well, could you give me a hand
thank you very much

Español

Si bien este post va dirigido a VADIM, bienvenida cualquier ayuda al respecto

Yo tengo una base de datos llamada gestion
la base tiene dos tablas
1 tabla llamada propietarios
-- los campos son: carpeta (este campo es primary key)
apellido
nombres
direccion
telefono
email

la segunda tabla se llama propiedades
cuenta con los siguientes campos

Carpeta (primary key)
Propiedad

Yo necesito relacionar ambas tablas para que al buscar la carpeta que es el campo en comun me muestre los datos de la tabla 1 y la 2 pero no puedo lograr darme cuenta, he leido el ejemplo pero la verdad no alcanzo a comprenderlo bien podrias darme una mano
desde ya mil gracias

#2 · August 24, 2022, 5:56 pm

Quote from PaulJonestindall on August 24, 2022, 5:56 pm
When relating two tables, each table must have a common field and these two fields are then linked.

In Table 1 you have field Folder.
In Table 2 you have field Folder also.

You define a relationship between the two tables by making Table 1 the master and selecting the Folder field as your link. Table 2 will be your detail table and you select the Folder field as your link. The two tables are then linked by each Folder field.

When you select a record in Table 1, it acts like a query of Table 2. Whatever data is in the Folder field in Table 1, that will be used as its query of the Folder field in Table 2.

In the below example, if you select the second record in Table 1, Table 2 will only show records where the Folder field has the same data as the Folder field in Table 1.

Table 1 (Master) Table 2 (Detail)
----------------------------------------------- -----------------------------------------------
Folder |Name |Date Folder |Time
----------------------------------------------- -----------------------------------------------
10001 |Jones |8/24/2022 10002 |02:14
->10002 |Smith |8/24/2022 10002 |05:15
10003 |Johnson |8/24/2022 10002 |13:35
10004 |Wilson |8/24/2022 10002 |17:05

I hope this helps.

When relating two tables, each table must have a common field and these two fields are then linked.

In Table 1 you have field Folder.
In Table 2 you have field Folder also.

You define a relationship between the two tables by making Table 1 the master and selecting the Folder field as your link. Table 2 will be your detail table and you select the Folder field as your link. The two tables are then linked by each Folder field.

When you select a record in Table 1, it acts like a query of Table 2. Whatever data is in the Folder field in Table 1, that will be used as its query of the Folder field in Table 2.

In the below example, if you select the second record in Table 1, Table 2 will only show records where the Folder field has the same data as the Folder field in Table 1.

Table 1 (Master) Table 2 (Detail)
----------------------------------------------- -----------------------------------------------
Folder |Name |Date Folder |Time
----------------------------------------------- -----------------------------------------------
10001 |Jones |8/24/2022 10002 |02:14
->10002 |Smith |8/24/2022 10002 |05:15
10003 |Johnson |8/24/2022 10002 |13:35
10004 |Wilson |8/24/2022 10002 |17:05

I hope this helps.

luishp and Vadim have reacted to this post.

#3 · August 25, 2022, 7:06 am

THANKS! @pauljonestindall Your help fix my problem

Best Regards

from neodbpro - Forum

from neodbpro