I've been tasked with designing a database to track cases for police investigations. I have a question regarding table design/normalization. Should I create a separate table for offender info and their address? My thinking is an offender can be linked to several address and/or several offenders can live at the same address. The problem I have with this is entering the data for the address. I would think it would be easier to type in the offender info then select an address from a combo box but what do you do if the address isn't in the table already? Seems like I would have to work backwards by entering in addresses first then enter in the offender information.