In the previous tutorial we left out two main things...the price of the product and the ability to only print certain labels. Both of these problems can be addressed with prompts.

First off, lets address the price. Products are typically resold for different prices so it would be good if we could enter in the price of the label for each product. So first off let's add a new Text label for the price.

Go to the label's properties and then select the "More Options" button. Now go to "Prompting". Enable the "Prompt at Print-Time" and then enter a message reminding the user to enter the cost. We also want this prompt to show up at every record (which is a product in this case) so set the "Prompt Frequency" to "Every Record".

We could leave the prompting for price at this however there is a problem with the bartender program it does not show the current label when the user is prompted. So athough there will be a prompt for every product it would be difficult to remember what product you are on since it gives you no indication. To get past this problem we are going to have the default text set as the catalog code. So go to the text label's properties, set the source to "Database" and user field to "prdtl1.prdperno".

First off change the source from "Screen Data" to "Database". Then set the "Use Field" to "prdtl1.prdperno" (the catalog code). Press Ok to continue.

Next we'll add prompting so that we can input the exact label we want to be printed. To do this first go into the database setup ("File/Database Setup") and goto the "Query" tab. Set the Field to "prdtl1.prdperno" (the catalog code) and select "New Prompt" for the Criteria.

Give the new prompt a reasonable name and enter a prompt that the user will see when asked to enter the catalog code. Exit the window and we're ready to print.

I should also note that you could have selectively chosen from a list of all the products to print by going "Select Records" on the print screen. However, if you've done the last few steps it will prompt you and you'll only see one product if you entered a correct catalog code.

Back to tutorials index