Download PDF file (424K bytes)

Chapter 11: Queries which Join Records
46
11.1 Foreign Keys
A better way would be to separate the addresses and people into different record sets. The first
record set might look like this:
%rec: Person
%type: Dob date
%type: Abode rec Residence
Name: Alfred Nebel
Dob: 20 April 2010
Email: [email protected]
Abode: 42AbbeterWay
Name: Mandy Nebel
Dob: 21 February 1972
Email: [email protected]
Mobile: 0555 342123
Abode: 42AbbeterWay
Name: Bertram Nebel
Dob: 3 January 1966
Email: [email protected]
Abode: 42AbbeterWay
Name: Charles Spencer
Dob: 4 July 1997
Email: [email protected]
Abode: 2SerpeRise
Name: Dirk Spencer
Dob: 29 June 1945
Email: [email protected]
Mobile: 0555 342123
Abode: 2SerpeRise
Name: Ernest Wright
Dob: 26 April 1978
Abode: ChezGrampa
and the second (following in the same file), like this:
%rec: Residence
%key: Id
Address: 42 Abbeter Way, Inprooving, WORCS
Telephone: 01234 5676789
Id: 42AbbeterWay
Address: 2 Serpe Rise, Little Worning, SURREY
Telephone: 09876 5432109
Id: 2SerpeRise