 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Database Design / June 2007Table Problem
I have a database with two tables. (Access 2003) In table1, there is a lookup field that uses table2 (table2 contains employee names). For some reason, Access is assigning the data type of that field to NUMBER. When I try to do a query on that field based on a persons name (Smith, John), I get a data type mismatch. But Access won't allow me to set the data type..it does it on it's own. What am I doing wrong? Thanks > I have a database with two tables. (Access 2003) > [quoted text clipped - 11 lines] > > Thanks Using a lookup field. When doing so you are NOT seeing what is in Table1 you are seeing what is in Table2. Is this confusing? Yes, and that is why the use of lookup fields is discouraged. See commandment number 2 at... http://www.mvps.org/access/tencommandments.htm  SignatureRick Brandt, Microsoft Access MVP Email (as appropriate) to... RBrandt at Hunter dot com Thanks Rick...but then how would I accomplish the same result by not using a lookup field? I want the user to be able to select the employee name from a drop down menu. > > I have a database with two tables. (Access 2003) > > [quoted text clipped - 18 lines] > See commandment number 2 at... > http://www.mvps.org/access/tencommandments.htm Hello again Rick..did some looking around..gonna try COMBO BOX..unless there are commandments against those too!! haha > Thanks Rick...but then how would I accomplish the same result by not using a > lookup field? [quoted text clipped - 25 lines] > > See commandment number 2 at... > > http://www.mvps.org/access/tencommandments.htm > Hello again Rick..did some looking around..gonna try COMBO > BOX..unless there are commandments against those too!! haha Absolutely not. The use of ComboBoxes and lookup *tables* is perfectly fine and reflects proper design. It is only the use of lookup *fields* that is not a good idea. SignatureRick Brandt, Microsoft Access MVP Email (as appropriate) to... RBrandt at Hunter dot com |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.