Recent content by Bob Wolf

Access is linked to Visio. Drag a Visio shape to the drawing page (a box); Visio pops up a dialog requesting a record (select from a listing of all records in the linked table by viewing the Primary Key, such as "ID"); all related fields in the Visio shape then populate with data from from the...

Thanks Wayne, Your third assumption is on point. I believed I had indeed grouped subsets of BigTable keys by collecting them in separate tables named ‘First’, ‘Second’ … ‘Two-Hundred’. Since these many lookup tables have only a single field (BigTableID, in your parlance), the only way to...

BIG-TABLE contains 1,000 detail records of 10 fields each. LOOKUP-TABLE contains maybe 50 records of 1 field each. ID is the field common to both tables, and is the primary key in BIG-TABLE. Lookup-Table is named “FIRST” (the First subset of records to be printed). SUBSET-QUERY drives...