davegauthier
New member
- Local time
- Today, 00:42
- Joined
- Dec 10, 2005
- Messages
- 8
I am creating a db for a property management company. They want to be able to enter the monthly payment made each month on each property (there will be multiple properties involved) and also have a field that totals all payments made by the tenant over the course of their lease.
What might be the best structure for this type of situation?
Should I create 12 fields for a year of monthly payments for each record?
Should I create a seperate table for each property and it's payments?
Should I create an Excel spreadsheet for the payments and link that file to the db as a table?
Any help and suggestions on this are greatly appreciated. Thank you in advance.
Dave
What might be the best structure for this type of situation?
Should I create 12 fields for a year of monthly payments for each record?
Should I create a seperate table for each property and it's payments?
Should I create an Excel spreadsheet for the payments and link that file to the db as a table?
Any help and suggestions on this are greatly appreciated. Thank you in advance.
Dave