Impression de plusieurs champs sur une ligne
Bonjour, j’utilise 2 tables : une DSA DAE l’autre facture
- je dois récupérer des infos de la table DSA DAE (image 109) pour les imprimer sur la facture (image 110).
- j’arrive à récupérer les champs sur la table DSA DAE sur la facture, mais je n’arrive pas à imprimer les différents champs sur une même ligne, voir exemple dernière capture image 108.
merci pour vos retours.
2 replies
-
Take a look at your cloud DB. I created a new tab on the Facture client DB and created a new formula field with the following code:
'DSA 1'.'N° interne' + " " + 'DSA 1'.'Marque & modéle'.'Marque et modéle DM' + " " + "N°" + 'DSA 1'.'N° série' + " " + 'DSA 1'.'Site / service / N° Cde'Then I added this new formula field to the print layout. It works but is clumsy.
Something that will help in your printing with the old print engine, is to create a new child table of Facture client. You can call it 'éléments de facture' (sorry for the bad google translation). Now Ninox will display the linked records for you in a list in the print layout.
If you find yourself creating fields with the same name and end with a different number, like you do with DSA 1, DSA 2, DSA 3, DSA 4, etc, then you should create a child table. Then that child table has a link to Facture client and to DSA. This way you can create 1 linked record or 10000 linked records.
Also, may I recommend that you merge all of your product (Marque) tables into one. As they all store the same type of data. You can then create a simple choice field that will differentiate between the products.
In the new Marque table will be a new child table called Images. This way you can store 1 image or 1000 images of a particular item.
Something else you may want to consider is to learn how to use the dynamic printing. It is a much better printing system. You can see this example or attached.
Content aside
- 2 wk agoLast active
- 2Replies
- 31Views
-
2
Following


