Query Prompt From Multiple Databases 关注

Legacy Poster

Hi guys,

I hope this makes sense, I have 2 spread sheets that i am trying to access via a single query prompt, is this possible?
Both spread sheets contain the same column headings just different data, for example..

[code]Spread sheet 1 (English Language)
Product Name PLU PackSize
Product 1 00100 14 Pack

Spread sheet 2 (German Language)
Product Name PLU Packsize
Produkt 2 00101 14 Pack[/code]

I am trying to create a query prompt that searches both spreadsheets by the PLU field.

Many thanks for any help that can be provided.

1 评论

Domingo Rodriguez
评论操作 固定链接


Are you trying to connect to two sheets within the same Excel spreadsheet, or are you trying to connect to two different Excel files?

Before creating a query prompt, you will need to establish a Join between these two spread sheets you're trying to connect to. Have you done this already via BarTender's database connection setup dialog? Without a Join you won't be able to proceed.

After creating the Join, you can still create a query prompt which will do the search on the new view which resulted from doing a Join between the two tables / databases. You would just choose the "query prompt" and create your prompt.

The below post might also be interesting to you:
[url="http://seagullscientific.invisionzone.com/index.php?/topic/258-illegal-database-join/"]See Post[/url]