Aller au contenu principal

Recherche

Recherche

Printing multiple records on a single sheet with query prompt

Commentaires

3 commentaires

  • Avatar
    Peter Thane

    It sounds like you may need to use a Record Picker table instead unless you can adjust the Prompt in some way to make it pick out the records you want to include, perhaps searching on a different parameter or using a Contains instead of an Equals for example

    0
  • Avatar
    Dave Elger

    Thanks for the reply Peter, I'm getting closer.  I found that my database setup Filter was set to AND when it should have been OR.  So now I have my 8 query prompts set up in the form and it will print the 8 labels in succession on the page.  My query prompts are using Autocomplete from Query Prompt Values rather than record picker right now because it is seems to be easier for user entry. 

    Which leads to my next problem...Because of this OR filter, if I enter the same sku into two different query prompts, that sku will only print one label when I want it to print on two. It is printing one label for each unique sku value.  How do I adjust my Filter to recognize that if a query prompt sku value is entered twice, that it should print 2 copies of the same label?

    In below screenshot, there are 6 unique values, so it will print only 6 labels.

    0
  • Avatar
    Peter Thane

    I dont think you can do it that way, as all the values would need to be unique. 

    It looks to me like you need to go down the Record Picker table route, with a quantity selector field and select the items you want the number of each on there

    0

Vous devez vous connecter pour laisser un commentaire.