How To Configure A Drop Down Menu In Bartender Follow

0
Avatar
Legacy Poster

I am trying to replace another software title with BarTender.

I have an Access database that needs to be used. The person printing the label, needs to do the following:

1- open Print Station and choose label


2- use a dropdown list to select OUR part number (table1)


** - OUR partnumber will print on the label as TEXT, it will cross
ref (using the db) to the CUSTOMER part number which will populate a
TEXT field and a BARCODE. In addition, there are several other TEXT
fields that will populate all because we selected OUR part number.

 

3 - the person printing will now select a Ship To City (table2) from another dropdown list, which will then populate additional fields.

4- there are a few manual text entry fields as well.


I have been trying to make this work for hours and am getting no where. I have tried the help file and user manual, but no luck.

 

ALSO, We are using 2 tables and I completely do not understand the need to "join" the tables (but the software seems to be forcing me to JOIN them). In fact, I don't think that will help because the data in Table2 is completey independant of Table1. I tried splitting this into 2 databases and it also forces me to JOIN the 2.

6 comments

0
Avatar
Legacy Poster
Comment actions Permalink

Wow wouldn't that be great if you could populate a dropdown selection based on a datafile... I think there are current workarounds, but it is not as friendly as you might imagine for this type of functionality.

As for your JOIN question. The reason a JOIN is required is that when you're querying your database, BarTender only knows how to pull one record for each label. Therefore it needs to know what to pull from each table. I am not sure how this works if your two tables share no links... I haven't done much with something like that.

Fortunately, BarTender is very flexible and can be controlled via .NET, which may end up being the best movement forward for your needs. Designing a .NET form that does your database stuff up front, then sends the label off to printing...

0
Avatar
Legacy Poster
Comment actions Permalink

nRyder, Thanks for your reply (months ago) I didn't get any notifications that I had a reply. Just found the time to get back onto this task. I don't feel that my 2 databases need joined. In our old labeling program, for this label, the user selects (from a drop down list) the Part Number, it then populates a few fields with information, then the user selects another drop down (reads the 2nd table) to select the SHIP TO city which populates more fields. Seems pretty simple, not sure why BT is complicated.

0
Avatar
Michael Toupin (mtoupin
Comment actions Permalink

There are two situations here that we'll want to address.  

 

First off, the drop down menu situation.  Currently, BarTender doesn't have a built-in mechanism to populate a pulldown menu with database data then use that response as data to populate a database query.  We're aware that this is a concern and are working towards implementing it in a newer release, but currently there's not an easy way to achieve this end result.  

 

The way to implement this right now from inside of BarTender is to write Visual Basic scripts that will connect to the database, poll the database, get the data from a column, create a dropdown with that information, receive a response, then use that response as a database query and populate fields based off of that result.  You can find some samples of how to do this in the VB Scripting section of the forums: http://forums.seagullscientific.com/index.php?/forum/61-vb-scripting/

 

Secondly, the fact that you're wanting to use two databases would usually require a database join.  However, if you use the above method to create the database connections manually, you wouldn't need that, you'd just create two scripts that do the connections for each data source separately.

 

Now of course if you're considering a .NET solution for this you'd handle all this in the .NET front end and simply pass two fields of data to the program to populate database queries with.  This would require a database join to achieve this with, so you'd want to make sure that you have a common field between the two databases if you wanted to do that in this situation.

0
Avatar
Legacy Poster
Comment actions Permalink

Thanks Mike, I thought I would give up on the drop down and use a query but as you said, that was the 1 way to do it without doing a database join. Can I upload my db's and btw and have someone configure this?

0
Avatar
Legacy Poster
Comment actions Permalink

Hi Mike,

 

Is this drop down box you mentioned above "implementing it in a newer release" is it now in the current version of Bartender?

 

thanks

 

Paul

0
Avatar
Legacy Poster
Comment actions Permalink

The "current version" of BarTender is still the same... so no...

Please sign in to leave a comment.