I am trying to design a database that contains information about residents and staff of an aprtment complex. I was hoping someone could help me with the best desing when staff can also be residents. I am trying not to have redundancy in the database.
Thanks for help. I think I am going to setup a person table that hold name, address, phone, etc.., and then have a table that holds information related to a staff member and a table with info related to a resident. I like you idea for a flag so that I can use that in a query. Thanks again for your help.
The idea is I have a complex which has residents that live there. The staff is both live-in and non-live-in. I need a way to hold all there information in one database and relate the information in such a way to keep them separate or together. I hope this makes some sense.