Sample Searches on Multiple Levels
Sample searches that depend upon two tables in DS-Access (and sometimes more than one field in a given table); the last example depends upon three tables:
1. I would like to see all the dated manuscripts that belonged to Sir Thomas Phillipps.
Represents searches at Manuscript level (tblMS) in "Provenance," and at Part level (tblMsPt) for the yes/no box for "Dated."
Should respond with:
Lodge MS 08
Plimpton MS 106
Plimpton MS 139
Plimpton MS 145
Smith Western Add. MS 10
X87.B45
X878.B23
2. I would like to see all the manuscripts bound in limp vellum and written in French.
Represents searches at Manuscript level (tblMS) in "Binding," and at Part level (tblMsPt) in "Language(s)."
Should respond with:
Montgomery MS 15
Plimpton MS 229
Plimpton MS 284
Smith Western Add. MS 07
Smith Western Add. MS 09
3. I would like to see all the manuscripts on paper but with seals (or evidence thereof).
Represents searches at Manuscript level (tblMS) in "Physical Issues," and at Part level (tblMsPt) in "Support."
Should respond with:
Smith Documents 076
Smith Documents 0418
Western MS 56
4. I would like to see all the codices and fragments of texts written by Boethius, copied during the thirteenth century, in a gothic script.
Represents searches at Part level (tblMsPt) in "Date" and in "Script," and at Text Level (tblEDoc) in "Author."
Should respond with:
Plimpton MS 165
Plimpton MS 166
5. Do you have any manuscripts of Sarum use, and in particular the books of hours produced in the Netherlands for export to England?
Represents searches at Part level (tblMsPt) in "Country," and at Text level (tblEDoc) for "Supplied Title."
Should respond with:
UTS MS 50
6. I'm researching Cistercians manuscripts produced in Austria.
Represents searches at Manuscript level (tblMS) in "Provenance" and at Part level (tblMsPt) in "Country."
Should respond with:
Med/Ren Frag. 90
7. I would like to see all the French bible leaves from the Otto F. Ege collections.
Represents searchs at Manuscript level (tblMS) in "Provenance," at Part level (tblMsPt) for "Country," and at Text level (tblEDoc) for "Supplied Title."
Should respond with:
Med/Ren Frag. 22
Med/Ren Frag. 23
Med/Ren Frag. 29