Results 1 to 2 of 2
  1. #1
    Access_Novice is offline Competent Performer
    Windows 7 64bit Access 2013
    Join Date
    Sep 2013
    Posts
    265

    How to make field names show instead of ID numbers

    In the attached database, I am working with the form called "frmParents" which has a subform on it. Go to record number 6 of the main form and you will see some values for the subform. In the "ClassName" field I have the classID, but I want the actual classname to display. I know I can do this by using a Lookup data type in the underlying table, but I've read posts advising not to use Lookup in tables. So what is the best way to do this?



    Also, notice how the last column of the sub form has a field called "Parent" which contains an ID number. I didn't want to add this field to the subform, but I had to do this, so that I can link the main form and subform by the parent ID field. I don't want this field to display. I set the visible property of that field in Design View to 'no' and it still shows. How do I make it not visible with form properties? I know I can right click and hide the field, but I would rather do it with the visible property.
    Attached Files Attached Files

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    49,479
    Don't use lookup in tables. Use lookup in form, namely in a combobox RowSource property.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

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

Similar Threads

  1. Replies: 2
    Last Post: 08-21-2013, 05:30 PM
  2. Changing names to ID numbers
    By marksnwv1957 in forum Access
    Replies: 4
    Last Post: 08-28-2012, 03:47 PM
  3. Names not Numbers
    By leeli67 in forum Database Design
    Replies: 12
    Last Post: 02-27-2012, 11:42 AM
  4. How do I make a field represent other field names?
    By Alpana in forum Import/Export Data
    Replies: 6
    Last Post: 01-15-2012, 08:41 PM
  5. Replies: 3
    Last Post: 04-12-2009, 05:11 PM

Tags for this Thread

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 - Senior Forums