> I have seen people create a fixed design database where there is exactly
> one field that holds street name and number, another field that handles
> city etc.

This will be the design we will be following.

> Please detail the compleate environment you are in and where you have
> grey areas that can be addressed.

As I am doing only preliminary research, I don't have all the details,
but here's a shot:

Person table will have Surname, Name, IDno, DOB, etc.

Address could be
a) in same table (AddressLine1, AddrssLine2, etc)
b)in a seperate table where each row is an address line and there's a
foreign key to the Person table
c) be a seperate table with a foreign keys to the Street table, the
Street table a foreign key to Suburb, etc.

My gut feeling is that Address will probably be done as per (a)

Jannie.