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

TITLE: Contacts default addresslist
VERSION: 1.1
REQUIRES: 0.70.01
DATASET: contacts
SQL:
{
	select contacts.tag, addresses.tag, addresses.main, addresses.label, contactlabel.descrip,
		addresses.address1, addresses.address2, addresses.city, addresses.state, addresses.pcode
		from contacts, addresses, contactlabel
		where contacts.tag = addresses.tag
		and addresses.label = contactlabel.tag
		and addresses.main=1
		and contactlabel.type='A'
}

COL1:
{
	label = Contact
	display = tag
}

COL2:
{
	label = Location
	display = descrip
}
COL3:
{
	label = Address 1
	display = address1
}
COL4:
{
	label = Address 2
	display = address2
}
COL5:
{
	label = City
	display = city
}
COL6:
{
	label = State
	display = state
}
COL7:
{
	label = ZIP Code
	display = pcode
}
