Data allocation in form/subForm

[Ayala]

Hi all,
I'm having trouble with my forms and/or table designs..
I'm very new in Access so I wish someone can help in a
clear and simple way.
I'm creating a Time Recording DB. The time recording is
done for 4 main areas, and for each area there's a list
tasks. So the personnel should keep record of the time
spent in activities for certain area. First I made 4
tables each for each Area. I need the user to type in his
name,the date, the activity (from a combo), and the total
hours for each area (if worked in the 4 areas that day)

I don't want the user to type his name and the date for
every activity he/she adds..
So I created a first table called tblDates, containing a
unique identifier, fldName, fldDate.
then 4 tables, for example for Sales Area: fldActivities,
fldHours, and a lookup field pointing to tblDates.

My intention is to have frmDates with sfrmSales but the
activities saved in sales are not saved in the correct
Date or person..

Any ideas??

 

[John S]

Me thinks you have a fundamental design problem: why do you need four
tables, one for each area. It sounds like you need maybe two tables, one for
employees, and one for ativities. (time recording) containing employee ID
(foreign key to employee table) , start tiime/date, end time/date, event
type, and (area [ if necessary]). Everything else can be derived from this
table. And you can use combo boxes so that employees can choose both areas
ansd events (assuming they are standard ones), to avoid problems.

John S
Aylmer, PQ.