Add A Database Query Prompt Into The Promt Design S’abonner

0
Avatar
Legacy Poster

Hi!

I am trying to design a label that selects fields from a database (excel-sheet). So far so good.
But i want it to be as userfriendly as possible and would like to add the database query into the promt design.

As it is now the database query appears first and after selection the promt design appears.

 

How to do this?

Please :) 

4 commentaires

0
Avatar
Legacy Poster
Actions pour les commentaires Permalien

you don't

0
Avatar
Legacy Poster
Actions pour les commentaires Permalien

Ok, so thats impossible.
Any other suggestions of alternative solutions?

0
Avatar
Legacy Poster
Actions pour les commentaires Permalien

You can do this is you are using 2016 but not in earlier versions. First you setup your query as normal and then on the Data Entry Form add a Text Input Box and then adjust the Linked source to the query. 

 

(FYI 2016 also allows you to add the Record Picker table (where a query isnt used) or as a Dropdown Record Picker) 

0
Avatar
Legacy Poster
Actions pour les commentaires Permalien

Can the Record Picker option be added to the template in 21016? I'm trying to allow the user to open an existing label, choose a different record from the data base and save it as a new label. The database record points to an external file containing the ingredient declaration for each product.

Thanks

Vous devez vous connecter pour laisser un commentaire.