question

[database]

If i hav a table named occupant (FirstName, LastName, Age, Contact, Marital status, Nationality) & visitor table (FirstName, LastName, Age, Contact).

is it advisable for me to merge them into the same table? If yes, How do i verify whether they are visitors or occupants?

[Allan Murphy]

It all depends how you use the tables.

If you want one table then in the Occupant Table add a field called Person Status to store Occupant or Visitor.

Preferably call your Occupant table Persons or something similar.

[HiTechCoach]

I generally put all people in a "people table".

I would then have a visitor table and a occupant that both link back to the the people table to get the name, etc.

This way I can track the history of a person. Each time they were a visitor (they might visit more than once) and also each time they were an occupant. I like to track this type of history for management reports, like how different marketing method work.

[database]

thanks for your help =)