A drop down table.

[Ted Clore]

I would like to have a Field that you click on for the purpose of adding employee times to a record on a daily basis.

For instance there would be a field that would have 25 entries where I could add employee ID, hours worked, and from another table pick what type of labor that was.

Can anybody help?

Thanks,
Complete Idiot,
Ted Clore

 

[Jeff Boyce]

You've posted your questions in the tablesdbdesign newsgroup. It sounds like you are trying to do this in a table.

If so, Access tables work great ... for storing data.

If you want to display and handle data, use Access forms. Combo boxes on forms do a great job of what you're describing.

Regards

Jeff Boyce
<Access MVP>

I would like to have a Field that you click on for the purpose of adding employee times to a record on a daily basis.

For instance there would be a field that would have 25 entries where I could add employee ID, hours worked, and from another table pick what type of labor that was.

Can anybody help?

Thanks,
Complete Idiot,
Ted Clore

 

[Vincent Johns]

I would like to have a Field that you click on for the purpose of adding
employee times to a record on a daily basis.

For instance there would be a field that would have 25 entries where I
could add employee ID, hours worked, and from another table pick what
type of labor that was.

I think you mean a "record" that would have 25 "fields", is that correct?

As far as picking out what type of labor to put into a field, yes,
Access provides a handy way to do this. You set the "Lookup" property
of the field to show you the list of items you want to choose from.

For example, suppose you have a [tblLaborTypes] Table in which the first
field is the Table's primary key and the second field contains the names
of different types of labor. Then you can open your Table in Table
Design View, and select the [LaborTypesID] field that will become a
foreign key pointing to [tblLaborTypes]. In the bottom half of the
Table Design window, click on the "Lookup" tab. Set the properties as
follows:
Display Control = List Box
Row Source = tblLaborTypes (you choose this from a drop-down list)
Bound Column = 1
Column Count = 2 (Access doesn't care if there are more than 2)
Column Widths = 0";1"

Switch to Table Datasheet View. Values in [LaborTypesID] will now be
displayed as names, but stored as key values hidden from human eyes,
making the Table much easier to work with.