Results 1 to 3 of 3
  1. #1
    NewInAccessBusiness is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Apr 2011
    Posts
    11

    Question Lookout wizard assistance required

    In the attachment, there is a database containing a table, named Hardware, which has a small problem.


    The fields named Type and MFR are set as scroll-downs by Lookout Wizard.
    But, when i try to insert new data type, or a new MFR, it doesn't save the newly inserted data type, and it would be a burden to have to type it out over and over rather than just to scroll it down and click it.
    Is there a way to set the fields up so that they save the new inserted data, while keeping the old ones already inserted?

  2. #2
    pmacbeth is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Apr 2011
    Posts
    3
    I would create a table [Types] with an ID and a [Description] field, and relate it to your [Machinery] table. Same for [MFR].
    You can find step by step instructions here. In particular, have a look at "Manually create a lookup field".

  3. #3
    NewInAccessBusiness is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Apr 2011
    Posts
    11
    It was very helpful, but the data i insert in the lookup wizard is not saved, rather it shows the message "The text you entered isn't an item in the list."
    Do you might know, or know anybody that does know, how to update the lookup wizard itself from the [machinery] table itself, by just typing inside the lookup column the new info, and having the table saving the new type of information by itself?

Please reply to this thread with any new information or opinions.

Similar Threads

  1. New to Access - Looking for some basic assistance
    By Dave_EntryIT in forum Access
    Replies: 2
    Last Post: 03-27-2011, 11:25 PM
  2. Assistance with normalizing tables
    By racheliza79 in forum Database Design
    Replies: 3
    Last Post: 08-26-2010, 04:20 PM
  3. Assistance on DB Design required - please
    By Optimus_1 in forum Database Design
    Replies: 13
    Last Post: 07-05-2010, 04:38 PM
  4. Need Assistance with Forms
    By JDA2005 in forum Forms
    Replies: 5
    Last Post: 06-30-2009, 03:37 PM
  5. Query Assistance Needed
    By elotromanuel in forum Queries
    Replies: 1
    Last Post: 03-17-2009, 09:31 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums