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
|
|||
|
|||
Grouping Fields
I have three fields that I want to group together. An Employee ID , Last
Name, First Name so that when I type in the ID field the corresponding name fields will automatically fill in. Is this possible? |
#2
|
|||
|
|||
Dave
You posted in a "tables" newsgroup, so your question must relate to how to do this in a table... First, you don't want to! As a relational database, Access doesn't need to store a person's name more than once. Second (a "tables" newsgroup, remember), you DON'T want to be doing data entry directly in a table. Access tables store data, Access forms display it and get used for data entry & validation. Third, if you are forcing someone (even yourself) to remember EmployeeID, I'd like to introduce you to the combo box in Access forms. You can create a combo box based on an Employee table, displaying not the EmployeeID (who cares about the specific ID, it's the person that's important, right?!) but the person's information, then select the correct person. -- Good luck Jeff Boyce Access MVP "Dave" wrote in message ... I have three fields that I want to group together. An Employee ID , Last Name, First Name so that when I type in the ID field the corresponding name fields will automatically fill in. Is this possible? |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Outlook contacts doesn't allow all fields from Excel? | gnmcewen | Contacts | 0 | January 9th, 2005 04:21 AM |
Additional fields for form based parameter query/null fields | geeksdoitbetter | Running & Setting Up Queries | 2 | January 7th, 2005 10:05 PM |
Populate fields in Form Header based on header fields in startup f | Pat Dools | Using Forms | 0 | January 7th, 2005 03:19 PM |
Date form fields in Word 2003 | Andy | General Discussion | 1 | November 11th, 2004 11:06 AM |
Selecting Fields for Update | Steve Daigler | Page Layout | 4 | October 15th, 2004 02:13 PM |