Recent content by memphiszen

Hello all, I'm designing a property management database. There are many properties. Each property can have 1 or more units. How should I go about creating tables for these? Should I create a properties table and a units table? At first I thought I should just create one table called...

Wow thanks guys. You've given me some great information to work with. I'll work on these tips and let you know how it's coming along.

Hi and thanks in advance! I'm working on a rental property database. I have property, unit, tenant, and lease tables (plus some more). But my main problem right now is this: How can I refer to a particular combination of property/unit in the lease table (or anywhere else for that matter)? I...