Relação

The CATEGORIES column is in the first table, where it has the values 1 and 2. In the second table, there is a column called PRODUCTS, where the products are listed, and another column called CATEGORIES, with the corresponding values from table 1. Even so, it doesn’t work. Why is the relationship not working?

Can you specify what exactly is not working, with screenshots as well?

This is the first table, with the “CATEGORIA” column in Portuguese. The column contains “1” and “2”.

This is the second table with two columns: one named “CATEGORIES,” which contains “1” and “2,” and the second named “PRODUCTS,” which I wanted to relate.

Where is your relation? I don’t see a relation column.

Just a moment, I’ll try to add it.

When I try to add the relation column, this appears.

After saving the relation and clicking on the query button in each row, do you see a result? Seems correct to me considering you are using big tables. You might want to select the Match Multiple checkbox since you are doing a one to many relation with multiple matches.

2 Likes

I am relating the “CATEGORIES” column from the “previous-milk” table, where the numbers “1” and “2” are present, to the “CATEGORIES” column in the “affectionate-table” table, where “1” and “2” also appear, but in greater quantity. Am I doing the relation incorrectly?

Yep, I understand what you are doing.

Like I said:

Other than that, I don’t see a problem.

1 Like

It worked, thank you very much! Now I’ll scale it up, and if I need help again, I’ll come back here.

1 Like

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.