Selective sorting

B

Brittany

I have a residential database and I need to display the
resident at the unit on the reports to be printed. There
are owners of units, and some of those units are rented
by tenants. How can I display who lives in the unit
instead of showing both groups of people? Any
suggestions would be helpful!!
 
K

Kevin Sprinkel

Don't know what your table structures or your other design
goals look like, but if I were designing it from scratch,
I might have table structures similar to the following:

People
===================
PersonID AutoNumber
FName
LName
Address
HPhone
WPhone
Etc.

Apartments
====================
ApartmentID AutoNumber
Owner Integer (Foreign Key to People)
Resident Integer (Foreign Key to People)
SF
Apartment #
Etc.

Then simply sort your data on Resident.

HTH
Kevin Sprinkel
 
Top