|
| Inicio → WINDEV 2024 → Table control with multifile and one to many relation in column ? |
| Table control with multifile and one to many relation in column ? |
| Iniciado por guest, 15,dic. 2015 08:22 - 3 respuestas |
| |
| | | |
|
| |
| Publicado el 15,diciembre 2015 - 08:22 |
Hello,
I have a table control with columns from 2 tables related to eachother (multifile)
There is a 1 to many relation between those tables.
The first table is a product table the second is a table with the descriptions of the products in 4 different languages.
Now i want that in my table view there is a column that displays the 3 language for each product. when i use multi file and select the relations i have always the first language ?
How can i change this ??
Thanks ! |
| |
| |
| | | |
|
| | |
| |
| Publicado el 15,diciembre 2015 - 09:20 |
Hi Rudi,
Which WX product?
With regards to the languages, do you use WD multi-lingual features or are you storing each language in it's own field on the database? |
| |
| |
| | | |
|
| | |
| |
| Publicado el 15,diciembre 2015 - 09:54 |
Hello,
I use Windev 18 but i am on a database created by my Prestashop webshop and there are indeed several languages stored in apart fields in the database.
For example i have products table and a related table with the product id and the descriptions in four languages.
Now i want to make my own backoffice software in windev.
I want to make a table with coluns for product id and description in one language (not the first)
so i need to make a column with a record from the related table with two conditions
product id = .... and language ID = ...
Best regards. |
| |
| |
| | | |
|
| | |
| |
| Publicado el 15,diciembre 2015 - 15:01 |
Hi Rudi
that's not what the multi-file system is for, and I do not think that you can achieve what you want this way.
The multi-file system in a file table is there to get ONE matching record and take information from it.
For what you want, I would advise to create a query with the query editor with the main files and all secondary labels, then use that query as the basis file in your table
Best regards |
| |
| |
| | | |
|
| | | | |
| | |
|