Hi Mario,
You can't do it directly in a table. You will have to do it in a Form, see:
How to Populate Text Boxes with Multicolumn Combo Box Selections
http://support.microsoft.com/default.aspx?scid=kb;en-us;319482
ACC2000: How to Populate Text Boxes with Multicolumn Combo Box Selections
http://support.microsoft.com/default.aspx?scid=kb;en-us;322900
I hope this helps! If you have additional questions on this topic, please
respond back to this posting.
Regards,
Eric Butts
Microsoft Access Support
"Microsoft Security Announcement: Have you installed the patch for
Microsoft Security Bulletin MS03-026? If not Microsoft strongly advises
you to review the information at the following link regarding Microsoft
Security Bulletin MS03-026
<
http://www.microsoft.com/security/security_bulletins/ms03-026.asp> and/or
to visit Windows Update at <
http://windowsupdate.microsoft.com/> to install
the patch. Running the SCAN program from the Windows Update site will help
to insure you are current with all security patches, not just MS03-026."
--------------------
| Content-Class: urn:content-classes:message
| From: "mario" <
[email protected]>
| Sender: "mario" <
[email protected]>
| Subject: Linking one field of a table to another
| Date: Tue, 24 Feb 2004 11:40:53 -0800
| Lines: 32
| Message-ID: <
[email protected]>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="iso-8859-1"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
| Thread-Index: AcP7Dh1G0xPC/lMJRiuHQKgk1LUdxQ==
| Newsgroups: microsoft.public.access.tablesdbdesign
| Path: cpmsftngxa06.phx.gbl
| Xref: cpmsftngxa06.phx.gbl microsoft.public.access.tablesdbdesign:76262
| NNTP-Posting-Host: tk2msftngxa11.phx.gbl 10.40.1.163
| X-Tomcat-NG: microsoft.public.access.tablesdbdesign
|
|
| Lets say I have the following tables:
|
| Table Name: "t1"
|
| ActivityID AssignedTo Desc
| -------------------------------------
| 1 Tom Job1
| 2 Harry Job2
| 3 David Job3
|
|
| Table Name: "t2"
| Lets say following will be my fields for "t2":
|
| t2_ID
| ActivityID
| AssignedTo
| Desc
| ActionTaken
|
|
| I would like to have an drop down box for the ActivityID
| which will refer to the table "t1". Upon selecting the
| appropriate ActivityID, it should populate "AssignedTo"
| and "Desc" from t1.
|
| How would I implement this functionality in the table's
| datasheet mode and form mode when I do the data entry.
|
| Thanks
| Mario
|
