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