task question

I am going to make a table of employees information and a table of task

Task table will consist of follwoing
1 task Number
2 Task description
3 quantity per hour

Person could do anywhere from 5 to 10 tasks a night

The question is how can i make a sheet that person will enter following
1 employee id
2 date
3 task number
4 hours worked
5 quantity

but only want to enter the tasks that they did for that night

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...esign/200903/1

Hi ban 12,
if this a continuous form or a data sheet, you could use a combo to hold the
task list.
On each line, user could select which task to use for that row.

Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia


"bam12 via AccessMonster.com" u50037@uwe wrote in message
news:92bed8857dd01@uwe...
I am going to make a table of employees information and a table of task

Task table will consist of follwoing
1 task Number
2 Task description
3 quantity per hour

Person could do anywhere from 5 to 10 tasks a night

The question is how can i make a sheet that person will enter following
1 employee id
2 date
3 task number
4 hours worked
5 quantity

but only want to enter the tasks that they did for that night

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...esign/200903/1

The person would enter info every work day, so would that be a continous form?

I am new with access

Jeanette Cunningham wrote:
Hi ban 12,
if this a continuous form or a data sheet, you could use a combo to hold the
task list.
On each line, user could select which task to use for that row.

Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia

I am going to make a table of employees information and a table of task

[quoted text clipped - 13 lines]

but only want to enter the tasks that they did for that night

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...esign/200903/1

It doesn't have to be a continuous form.
Single forms have the navigation buttons at the lower left.
User can create a new task by clicking the new record button.

If using a continuous form, you might need to do some careful coding to get
the combo to show the correct task for each row.

Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia


"bam12 via AccessMonster.com" u50037@uwe wrote in message
news:92bf660edfad4@uwe...
The person would enter info every work day, so would that be a continous
form?

I am new with access

Jeanette Cunningham wrote:
Hi ban 12,
if this a continuous form or a data sheet, you could use a combo to hold
the
task list.
On each line, user could select which task to use for that row.

Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia

I am going to make a table of employees information and a table of task

[quoted text clipped - 13 lines]

but only want to enter the tasks that they did for that night

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...esign/200903/1

what would the primary key be?

1 employee id
2 date
3 task number
4 hours worked
5 quantity

Jeanette Cunningham wrote:
It doesn't have to be a continuous form.
Single forms have the navigation buttons at the lower left.
User can create a new task by clicking the new record button.

If using a continuous form, you might need to do some careful coding to get
the combo to show the correct task for each row.

Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia

The person would enter info every work day, so would that be a continous
form?
[quoted text clipped - 14 lines]

but only want to enter the tasks that they did for that night

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...esign/200903/1

post with details of your tables and relationships.
--primary key
--foreign key
--relationships

Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia

"bam12 via AccessMonster.com" u50037@uwe wrote in message
news:92d4debc6d79b@uwe...
what would the primary key be?

1 employee id
2 date
3 task number
4 hours worked
5 quantity

Jeanette Cunningham wrote:
It doesn't have to be a continuous form.
Single forms have the navigation buttons at the lower left.
User can create a new task by clicking the new record button.

If using a continuous form, you might need to do some careful coding to
get
the combo to show the correct task for each row.

Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia

The person would enter info every work day, so would that be a continous
form?
[quoted text clipped - 14 lines]

but only want to enter the tasks that they did for that night

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...esign/200903/1