I plan to create a relatively complex database in Microsoft Access. I would like to use this database as data source for xDxDataBook.
I create different tables not only for the parts (as in the starter library), but for example I would like to create a separate table for the distributors. This will enable me to easily modify the distributors.
Tables are joined in Access (for example: Distributor field in the IC table is joined with the distributor name field in the Distributor table)
Hence, in MS Access I can perform quite complex queries. (for example when I browse the IC table I can find not only the distributor (which is stored in the IC table) of a certain part, but also its address and phone number (read from the Distributor table))
When I set up xDxDataBook can I use the result of MS Access Queries as datasource or only tables can be selected as data sources?
Yes, you can create a query inside MS Access, then have DataBook look at the query results instead of the raw tables.
Name the query with a prefix, like Q_, to make it obvious when you are building the DataBook configuration.