Multiply date fields

[amin]

Hi everyone
I have a MedService table with 20 fields (FluVac, dental, Smokeed, FootExam,
……)
I need to add for each one of these fields another 2 date fields
(CurrentDate, NewDate) .
Is there a way to not add 2 Dates fields to each one on the 20 service
fields. Like create a table with Dates and connected to MedService table, and
what is the relationship would be
Thanks

 

[Duane Hookom]

It sounds like this would be a good time to normalize your table structures.
"FluVac" should be a value in a field in a related table, not a field name.
If you want to add "EarsCleaned", this should not require the addition of a
field, controls on forms and reports etc.

Consider reading some resources on normalization. There are lots of links
from Jeff Conrads site
http://home.bendbroadband.com/conradsystems/accessjunkie/resources.html#DatabaseDesign101.

 

[amin]

thanks Duane
first: I'm building the database.
second: the "FluVac" and the other fields are to hold data in the table as
they are received or referred. Then the I need to add date received and date

 

[Duane Hookom]

If you have FluVac as a field name then I believe this is a normalization
problem.