Gettting Value From Multiple Tables
I have this SQL database and I have three tables: brining (variety_name, grower_name), variety (variety_name), and grower (grower_name). The brining table has 2 lookup fields from the variety and grower tables. Is there a way I can get the real value or name of the fields variety_name and grower_name instead of an assigned integer value? What I would like to get is the true value of variety_name and grower_name when I print the record.
Thank you for reaching us via the BarTender Community Forum!
Getting a set of values from multiple tables on your database can be done by using the join function on them. We have some documentation on the subject that we believe should prove of use to you:
Using Multiple Databases or Tables
About Database Joins
Please, review our support articles and feel free to reach us again if you have further queries on this subject.