More Than On Entry From A Database
Hello,
i´m looking for an solution to put more than on datarecord into a label.
To understand my problem here a small illustration
we have storageboxes No 1, 2 ,3 ..... and so on.
In these storageboxes are different spare parts e.g. Boxname: Engine Parts - Content: Ignition plug, main bearing, etc
These information is commig from a MySQL Database two tabels one for the storageboxes an on for die produkts. The two tabels are connected with an starage_id so i can filter the datarecords by this id.
The label should contain the Boxname and number and a list of its content. The first issue was easy to solve but the second on is difficult for me BarTender only writes one produkt on the label. How can i tell Bartender to use the next datarecord from the database? Is there an solution for this problem?
best regards
Erik
i´m looking for an solution to put more than on datarecord into a label.
To understand my problem here a small illustration
we have storageboxes No 1, 2 ,3 ..... and so on.
In these storageboxes are different spare parts e.g. Boxname: Engine Parts - Content: Ignition plug, main bearing, etc
These information is commig from a MySQL Database two tabels one for the storageboxes an on for die produkts. The two tabels are connected with an starage_id so i can filter the datarecords by this id.
The label should contain the Boxname and number and a list of its content. The first issue was easy to solve but the second on is difficult for me BarTender only writes one produkt on the label. How can i tell Bartender to use the next datarecord from the database? Is there an solution for this problem?
best regards
Erik
0
-
Hi,
We also faced the same issue, we solve this by adopting alternative option like make content records into columns as many required. create multiple columns for each box like Ignition plug1, main bearing1, Ignition plug2, main bearing2, Ignition plug3, main bearing3 upto maximum contents records for label based on your requirement. Now you can design label as you required.
-------------------------Label Design------------------
Boxname: 12345
Engine Parts
----------------------------
Ignition plug main bearing
----------------------------
Ignition plug1 main bearing1
Ignition plug2 main bearing2
Ignition plug3 main bearing3
Ignition plug4 main bearing4
-------------------------Label Design------------------
Regards,
Anil
[quote name='ehuellen' timestamp='1331713478' post='1984']
Hello,
i´m looking for an solution to put more than on datarecord into a label.
To understand my problem here a small illustration
we have storageboxes No 1, 2 ,3 ..... and so on.
In these storageboxes are different spare parts e.g. Boxname: Engine Parts - Content: Ignition plug, main bearing, etc
These information is commig from a MySQL Database two tabels one for the storageboxes an on for die produkts. The two tabels are connected with an starage_id so i can filter the datarecords by this id.
The label should contain the Boxname and number and a list of its content. The first issue was easy to solve but the second on is difficult for me BarTender only writes one produkt on the label. How can i tell Bartender to use the next datarecord from the database? Is there an solution for this problem?
best regards
Erik
[/quote]0
Iniciar sesión para dejar un comentario.
Comentarios
1 comentario