|
|
|
#1
03-02-2010, 08:57 AM
|
|||
|
|||
Table with look-up columns
I have 2 tables in a database. 1 is a for projects and one is for contacts.
I have inserted a look-up column in my projects table that looks for a contact name from the contacts table. I want additional fields in the projects table to be filled with values from the contacts table based on the look-up column selection and I can not figure it out. Any help would be greatly appreciated. Thanks 
|
|
#2
03-02-2010, 09:33 AM
|
||||
|
||||
|
With forms not an issue, but users should not see tables and you should not be using Lookup Fields.
__________________
(RG for short) aka Allan Bunch MS Access MVP - WinXP Pro, Win7 - acXP, ac07 If your issue is resolved...follow this link for directions on how to use the Solved thread tool! Teaching is not filling a bucket but lighting a fire. Borrowed quote..."Docendo discimus"
|
|
#4
03-02-2010, 11:09 AM
|
||||
|
||||
|
All the more reason not to use a Lookup Field.
__________________
(RG for short) aka Allan Bunch MS Access MVP - WinXP Pro, Win7 - acXP, ac07 If your issue is resolved...follow this link for directions on how to use the Solved thread tool! Teaching is not filling a bucket but lighting a fire. Borrowed quote..."Docendo discimus"
|
|
| Bookmarks |
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| update Linked Table Definitions after the table has columns added/Altered | sesproul | Access | 3 | 01-21-2010 05:10 PM |
 Date columns linked to AS400 table not formatted as dates
|
vessellcpa | Access | 3 | 11-19-2009 06:15 PM |
| adding the values of two columns in a table | chum | Access | 1 | 10-09-2009 09:52 AM |
| sub-reports and columns | blg | Reports | 0 | 02-21-2009 08:11 PM |
| How to create SUBORDINATE columns in a table | kilimche | Forms | 3 | 09-19-2008 12:19 AM |
Windows 7 
Access 2007 (version 12.0)
Linear Mode
