Newbie help please - Configuring two separate excel tables onto one form
I am very new to Bartender. I have an excel file which has two separate tables, one with items and the other with customer delivery addresses. I am creating an input form where I want the user to select the item and the delivery depot.
I was hoping to do this with two separate dropdown record pickers, however I see I can only have the one record picker. Both record sets would have a many to many relationship. I did try linking the two record sets but this creates far too many rows.
Is what I am wanting achievable?
If so, are there any guides or YouTube videos I can follow to show me the principle?
Many thanks in advance
John
-
pthane
★ BarTender Hero ★
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.
Comments
1 comment