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
|
|||
|
|||
Lookup Table Format
Hi all.
I have come across a problem with using a linked value in a lookup value. The situation has arisen trying to format an aircraft register. Table1: tblAircraftRegister AC_ID -- (Primary Key, Autonumber) Engine -- (Lookup Table Wizard, lookup table has been set to display the engine manufacturer and model from tblEngine) Table2: tblEngine ENG_ID-- (Primary Key, Autonumber) EngineManufacturer -- (Lookup Table Wizard, connected to refEngineManufacturer) EngineModel --- (text field) Table3: refEngineManufacturer ENG_MANUF_ID --- (Primary Key, Autonumber) EngineManufacturer -- (text field) The display for the drop down box for the engine field in tblAircraftRegister has the format: ENG_MANUF_ID (a number) EngineModel (text) What I would like to see is : EngineManufacturer (text) EngineModel (text) My apologies if it is difficult to understand my explanation of the problem. Cheerio, Timbo. PS If you email my account, expect a reply challenging your authenticity as a person. Sorry, but you get that trying to keep SPAM out. |
#2
|
|||
|
|||
Tim
A search through this newsgroup (tablesdbdesign) will reveal that a great many folks try to use the Lookup data type in Access tables ... and encounter problems like what you've described. A general recommendation is "Don't!" Don't use lookup datatypes in tables, as it leads to storing one value but displaying another (the "looked up" value). Instead, do you "looking up" in forms, via combo boxes. Access tables are great for storing data, but Access forms really shine when it comes to displaying it. If you are trying to get the selection in one field to limit selection in another, check the forms newsgroup (or Google.com) on the topic of "cascading combo boxes". -- Good luck Jeff Boyce Access MVP "Tim McKeaveney" wrote in message ... Hi all. I have come across a problem with using a linked value in a lookup value. The situation has arisen trying to format an aircraft register. Table1: tblAircraftRegister AC_ID -- (Primary Key, Autonumber) Engine -- (Lookup Table Wizard, lookup table has been set to display the engine manufacturer and model from tblEngine) Table2: tblEngine ENG_ID-- (Primary Key, Autonumber) EngineManufacturer -- (Lookup Table Wizard, connected to refEngineManufacturer) EngineModel --- (text field) Table3: refEngineManufacturer ENG_MANUF_ID --- (Primary Key, Autonumber) EngineManufacturer -- (text field) The display for the drop down box for the engine field in tblAircraftRegister has the format: ENG_MANUF_ID (a number) EngineModel (text) What I would like to see is : EngineManufacturer (text) EngineModel (text) My apologies if it is difficult to understand my explanation of the problem. Cheerio, Timbo. PS If you email my account, expect a reply challenging your authenticity as a person. Sorry, but you get that trying to keep SPAM out. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
transpose | john | Using Forms | 1 | November 24th, 2004 07:16 PM |
Manual line break spaces on TOC or Table of tables | Eric | Page Layout | 9 | October 29th, 2004 04:42 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 |
Complicated Databse w/many relationships | Søren | Database Design | 7 | July 13th, 2004 05:41 AM |
Make a field lookup dependent on the value in another field of a record? | Susan A | Database Design | 8 | May 22nd, 2004 09:10 PM |