How to Create a querry if two databases are connected in one document.
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?
-
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
Please sign in to leave a comment.
Comments
1 comment