Cross data between tables in LO Base (Data Base)

[jtm4890]

I wish to create a new table using 2 tables like this:

Table 01:

Cable SIZE / UNITS
2.5 /MM2
4 /MM²

Table 02:

Cable Type
NXOH
NH-80

then i wish cross like this table 03:

Cable / Price per meter
NXOH 2.5mm2 / S/0.1

is this possible?

[RobertG]

Are there any relations between the 2 tables? Or do you want row 1 from Table 01 connected with row 1 from Table 02?

[jtm4890]

Table 01 and 02 without relation, I wish something like a permutation (combine all elements of the columns using concatenate)

… Then I wish to concatenate columns from table 01 and 02, and when I have a table 03 then relate with another table 04 with prices.

But I wish that dynamically the table 03 and 04 change when I add more rows in tables 01 and 02

something like this video

- YouTube

[Wanderer]

@jtm4890

then i wish cross like this table 03:

Cable / Price per meter
NXOH 2.5mm2 / S/0.1

is this possible?

Yes, but you have ti write it yourself, as your S/0.1 is not part of your tables. (You could try a hallucinating AI…)

@jtm4890

without relation, I wish something like a permutation (combine all elements of the columns using concatenate)

For this your topic/title is quite good:
Google for SQL CROSS JOIN

[Villeroy]

Joining 2 row sets with HSQL: Apache OpenOffice Community Forum - [SQL] JOINing 2 row sets - (View topic)

[CRDF]

Something along this line?

[jtm4890]

@CRDF

Something along this line?

probably yes but with more data, something like this:

test_calcbase.ods (12.6 KB)

[CRDF]

But if say
NXOH combine itself with NH-80 as apparently it is your intention, how to know the price?
If NOT, if each type goes by itself, it will be a common many-to-many relationship.
(?)

[CRDF]

This is the many-to-many relationship via a “Junction Table”.