Access help, subform on a cont. form
I'm a fairly inexperienced access user so thanks in advance for your help.
I need to put a subform on an existing continuous form. If you can answer that or give me any tips with just that, then don't bother reading on. The rest is background and sort of the basics of what I am trying to do.
Basically what I've done is designed a database to keep track of daily logs within a busy department because I need the searchability and multiple user access you get from a database (before I did this everything was kept in a separate word.doc for EACH day...talk about a nightmare to search through)
I have two tables that I need to enter data on the same form. tblDailyLog is many records for one day on a continuous form for easy browsing. tblDutyLog is three entries that are static for the entire day (duty manager names for each of three shifts)
The way I have arranged everything is to have users enter data on a form called frmDailyLog The form is a continuous form so users can see other entries as they are making their own. A report is generated at the end of the day that is then published. Now I need to add a new feature...a section of the report that lists which duty manager was on duty during the three shifts.
I initially added the field to frmDailyLog but then realized that was no good because I had 30 entries with the same date in frmDailyLog and the three names of shift managers are static for the entire date. Next I tried a separate table called tblDutyLog. This has three fields (one for each shift), a date field and an ID field. This will work bu I need to be able to enter the data in both tables from one form. I haven't been able to do it.
Sorry this got so long...hope you can help.