Hi there,
I'll try to explain what I want to achieve.
I have tables with the following structure:
T1:
Order number|Number of racks
A1|3
A2|4
A3|1
T2:
Shelf|Number of free parking spaces
R1|3
R2|2
R3|5
R4|8
The tables are not related because there are no relationships between them.
I would now like to have an additional field (shelf suggestions) in T1, which should contain the shelves that can hold the number of racks:
T1:
Order number|Number of racks|shelf suggestions
A1|3|R1 R3 R4
A2|4|R3 R4
A3|1|R1 R2 R3 R4
Thank you for any food for thought.
