How to Create a querry if two databases are connected in one document.

Achmed Allah

• 2019年03月11日 20:23

Hi

I got following problem

I need to create vba macro that prints desired label, when user type order number,

To do this in bar tender document i connect two databases-one database contains info about product. Second database contains item number and item order. 

My problem is that i can't create querry on joined databases, using querry i was able to search for desired record. Is there anybody know how to create querry on joined database?

0

• 

  Peter Thane

  ★ BarTender Hero ★

  • 2019年05月01日 13:34

  If the databases are joined in the BarTender label then there must be a field in one that is the same in the other (ie the fields that you used to create the join). All you need to do is create a filter/query connected to the appropriate lookup value in one of the tables and the join will automatically search both tables at print.time for the required data 

  0

請登入寫評論。