#
# $Id: contactphonelist.rep,v 1.1 2000/07/12 03:19:41 billf Exp $
#

TITLE: Contacts default phonelist
VERSION: 1.1
REQUIRES: 0.70.01
DATASET: contacts
SQL:
{
	select contacts.tag, phones.tag, phones.main, phones.label, phones.number, contactlabel.descrip
		from contacts, phones, contactlabel
		where contacts.tag = phones.tag
		and phones.label = contactlabel.tag
		and phones.main=1
		and contactlabel.type='P'
}

COL1:
{
	label = Contact
	display = tag
}

COL2:
{
	label = Location
	display = descrip
}
COL3:
{
	label = Phone Number
	display = number
}
