How to Create a querry if two databases are connected in one document. フォローする

Achmed Allah


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?

1 コメント

Peter Thane

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