Auto Populating A Text Object 追蹤

0
Avatar
Legacy Poster

I am trying to design a new label for our stockroom. I have the label set up to ask for a part number, quantity and employee number. What I am having trouble with is getting it to auto populate the location. We have an excel file with part numbers and locations. I was hoping to be able to use the input for the part number to look at the excel file to find the corresponding location and print it on the label.

Hope that makes sense.

Thanks

2 意見

0
Avatar
Susan Chen
版主
評論操作 永久連結

Hi, Mishkakc:

You can setup a query propmt to achieve what you want

Step 1: Connect to the right database through Bartender
Step 2: On the File-> Database Connection Setup-> Click on “Query” Tab
Step 3: Setup a New Prompt
Step 4: On the Query Prompts screen, put the Query name(For example: Part number query) and Print-time user Prompt(For example: Part Number) in

Step 5: Test with File->Print Preview


It will show the corresponding location in the database for the selected part number



Thanks!
0
Avatar
Legacy Poster
評論操作 永久連結

[quote name='Susan C - Seagull Support' timestamp='1314266230' post='446']
Hi, Mishkakc:

You can setup a query propmt to achieve what you want

Step 1: Connect to the right database through Bartender
Step 2: On the File-> Database Connection Setup-> Click on “Query” Tab
Step 3: Setup a New Prompt
Step 4: On the Query Prompts screen, put the Query name(For example: Part number query) and Print-time user Prompt(For example: Part Number) in

Step 5: Test with File->Print Preview


It will show the corresponding location in the database for the selected part number



Thanks!
[/quote]


Hi Susan,

Followed your instructions and it works, thanks.

Just one more question though.

Here are the steps I need to take to print my label.

Click on Print - Print Wizard - Enter Data for Query window opens
I now type in the part number and click Prompt
Print Wizard - Prompt Dialog window opens
I then type in the Part Number (again), Quantity, and Employee #
Click Print and we get our label with the correct information.

Is there a way to enter the part number only once?

Thanks

登入寫評論。