S
Steve
I have just started building a database and have received some great advice
here. I've got several tables for our transitional housing program built.
Most of the information is date sensitive. I have a tblPerson with
relationships to tblApplication, tblLease, tblIncome,etc. The reports I'm
required to compile by different funding sources track income and other
things for each person over time. Usually the length of the tenancy. A
person can have several tenancy (lease) records over a period of time. I
already have been told that I need to use a StartDate and EndDate for much
of the information so that I can track it for a lease period. Because most
of my information is date sensitive I have many tables with StartDate and
EndDate. My question is: Isn't this redundant a lot of the time? Lot's of
people only enter our program once so they have an EntryDate and an
ExitDate. The StartDate and EndDate for their sources and amounts of income
would be the same. Is there a way to automatically enter their EntryDate
and ExitDate into the related tables StartDate and EndDate fields with the
option to override it? In other words. I don't want to have to have a
dozen intake forms each requiring a person to enter StartDate and EndDate.
Hope this makes sense.
TIA
Steve
here. I've got several tables for our transitional housing program built.
Most of the information is date sensitive. I have a tblPerson with
relationships to tblApplication, tblLease, tblIncome,etc. The reports I'm
required to compile by different funding sources track income and other
things for each person over time. Usually the length of the tenancy. A
person can have several tenancy (lease) records over a period of time. I
already have been told that I need to use a StartDate and EndDate for much
of the information so that I can track it for a lease period. Because most
of my information is date sensitive I have many tables with StartDate and
EndDate. My question is: Isn't this redundant a lot of the time? Lot's of
people only enter our program once so they have an EntryDate and an
ExitDate. The StartDate and EndDate for their sources and amounts of income
would be the same. Is there a way to automatically enter their EntryDate
and ExitDate into the related tables StartDate and EndDate fields with the
option to override it? In other words. I don't want to have to have a
dozen intake forms each requiring a person to enter StartDate and EndDate.
Hope this makes sense.
TIA
Steve