Want to display data from 2 tables in 1 RG

ewbubbleio · 2024-12-08T08:54:15.920Z

I have 2 tables and want to show fields from each table in 1 RG.

Table 1
name desc color
A this … black
B which … blue
C when … red
D who … yellow
E if … pink
F following … green

Table 2
count name
5 A
4 C
10 D
6 F

Setup table 1
name text
counter table 2
desc text
color text

Setup table 2
count number
name text

In both tables the primary key is the name field.

In the RG I would like to see the following list:
name count desc
A 5 this …
B which …
C 4 when …
D 10 who …
E if …
F 6 following …

When I run the app I get a blank in the count column for all rows.
Can anyone point me in the right direction?

krenkel · 2024-12-08T19:39:21.434Z

Hi, @ewbubbleio, I believe you need to create two tables, one must have some field of the same type as the other so you can call the data from two tables from one table. I’ll send you a printout containing the user data that I search for through the car table. As you will see, we have two customers with different cars, but the user comes from the user table and the car from the car table. But I search from just one table, the car table. I have this link between the car table and the user table.

2_tabelas348×220 8.26 KB

system · 2025-02-16T08:54:53.139Z

This topic was automatically closed after 70 days. New replies are no longer allowed.