Hi
I am having some difficulty structuring my access database to minimise data entry for this monthly episode diary that I currently have in excel. I have my database all set up with the one to many relationships with the study ID as the primary key and then this appears in all other tables as the foreign key.
I am struggling to structure the monthly episode diary in access.
In excel I type it once at the top but the way I have set it up means I would have to keep entering the date month for each of the 31 days of the month and also keep entering the study id 31 times for each month.
Is there a way I can auto populate the study id and month field so that they will be automatically entered for each of the day of the month?
I have a screen shot below of how it looks at the moment in excel – I basically want an easy way to fill down for study id and month as that will be the same for each day of the month.
The second screen shot is how I would want it to look in access – if possible!
Thanks in advance!
Lynn