Skip to main content

Search

Search

Newbie help please - Configuring two separate excel tables onto one form

Comments

1 comment

  • Avatar
    pthane

    You need to create a Join between the two sheets, where for example the "Product Code" in table 1 is equal to the "Material number" in table 2. You basically have to tell BarTender what unique element of data in each table is the same even if they have different field names. 

    If there is no direct correlation between the two tables then you can sometimes fool it by adding a field to each table with the same value for each record in each table and use that for the join (ie all have a field with a value of 1). You would then use your database filters/queries to select your required data with your product data from one and delivery depot from the other.

    Alternatively, link the labels itself to your product database and add the Depot selection option as a Data Entry>Drop Down list>Database object so that that element is selected independently at print time.  

    0

Please sign in to leave a comment.