-
question
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?
-
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.
Allan
-
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.
Boyd Trimmell aka HiTech Coach
Microsoft MVP - Access Expert
[SIGPIC][/SIGPIC]
Office Programming 25+ years as a Software Developer specializing in:
Business Process Management
Accounting/Inventory Control
Customer Relations Management (CRM)
Electronic Data Interchange (EDI)
-
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|