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
|
|||
|
|||
Troubleshooting Lookup Fields
Scenario:
Table 1 UniqueID is created= 2004-01 2004-02 and so on... Table 2 UniqueID is created from unique ID from Table 1 and another field using a general number= 2004-01 1 2004-01 2 2004-01 3 and so on... Table 3 UniqueID is created using Query that holds the unique IDs from Table 2 and another field using letters= 2004-01 1 a 2004-01 1 b 2004-01 1 c and so on... In Table 3, I see the two fields in the lookup drop down list. But after I have made a selection only the left most column is visible. I have played around with the column widths to no avail. So I don't know if this is feasible or should I be going about it another way. |
#2
|
|||
|
|||
Troubleshooting Lookup Fields
i suggest you remove the Lookup fields from your tables. see
http://www.mvps.org/access/lookupfields.htm for more information. use forms, with combo boxes to "look up" the linked data, for entering data into your tables. hth "blaqkikapoo" wrote in message ... Scenario: Table 1 UniqueID is created= 2004-01 2004-02 and so on... Table 2 UniqueID is created from unique ID from Table 1 and another field using a general number= 2004-01 1 2004-01 2 2004-01 3 and so on... Table 3 UniqueID is created using Query that holds the unique IDs from Table 2 and another field using letters= 2004-01 1 a 2004-01 1 b 2004-01 1 c and so on... In Table 3, I see the two fields in the lookup drop down list. But after I have made a selection only the left most column is visible. I have played around with the column widths to no avail. So I don't know if this is feasible or should I be going about it another way. |
#3
|
|||
|
|||
Troubleshooting Lookup Fields
I would advise against the LookUp Fields.
See The Access Web article: http://www.mvps.org/access/lookupfields.htm -- HTH Van T. Dinh MVP (Access) "blaqkikapoo" wrote in message ... Scenario: Table 1 UniqueID is created= 2004-01 2004-02 and so on... Table 2 UniqueID is created from unique ID from Table 1 and another field using a general number= 2004-01 1 2004-01 2 2004-01 3 and so on... Table 3 UniqueID is created using Query that holds the unique IDs from Table 2 and another field using letters= 2004-01 1 a 2004-01 1 b 2004-01 1 c and so on... In Table 3, I see the two fields in the lookup drop down list. But after I have made a selection only the left most column is visible. I have played around with the column widths to no avail. So I don't know if this is feasible or should I be going about it another way. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Access and Lookup Fields | blaqkikapoo | Database Design | 4 | August 10th, 2004 02:17 PM |
Lookup fields | Luis Miguel | Database Design | 7 | June 21st, 2004 02:54 AM |
Lookup fields on label report | Howard | Setting Up & Running Reports | 1 | June 3rd, 2004 02:43 AM |
Lookup fields - what's wrong with them? | NATHAN SANDERS | New Users | 2 | May 4th, 2004 10:51 AM |