task question

[bam12 via AccessMonster.com]

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

 

[Jeanette Cunningham]

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]

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

I am new with access

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

 

[Jeanette Cunningham]

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?

I am new with access

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

 

[bam12 via AccessMonster.com]

what would the primary key be?

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

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]

 

[Jeanette Cunningham]

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

Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia

what would the primary key be?

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

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