Selective sorting

  • Thread starter Thread starter Brittany
  • Start date Start date
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!!
 
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
 
Back
Top