If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
A drop down table.
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 |
#2
|
|||
|
|||
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 "Ted Clore" wrote in message ... 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 |
#3
|
|||
|
|||
Ted Clore wrote:
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. Can anybody help? Thanks, Complete Idiot, Ted Clore |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Help with relationship plase | Rock | General Discussion | 5 | July 4th, 2005 03:54 AM |
Help with relationship plase | Rock | Database Design | 5 | July 4th, 2005 03:54 AM |
Access combo box-show name, not ID, in table? | write on | New Users | 30 | April 30th, 2005 09:11 PM |
Table Wizard Does Not Set Relationship if Foreign Key and Primary Key Name Do Not Match Exactly in Case. | HDW | Database Design | 3 | October 16th, 2004 03:42 AM |
COMPARE THE TWO TABLES | Stefanie | General Discussion | 0 | June 4th, 2004 04:36 PM |