Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    Oct 2001
    Location
    Indiana, USA
    Posts
    21
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Display of muliple fields (Acess 2000)

    I have an Employee table joined to an Change Request table. The two tables are joined by an Employee Number. I want to allow the data entry person to choose a name from a Lookup table rather than the number.
    Secondly I have set up a FirstName and LastName field in the Employee table (I'm not sure this is the best way to set this up?). I need to combine these two on the form and report.
    I assume this can be done with a Query, but being a relative novice I am struggling. Any suggestions would be apprieciated.

  2. #2
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Sint Niklaas, Belgium
    Posts
    2,778
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Display of muliple fields (Acess 2000)

    In the combobox for the lookup table, add a field with the names and set the width of the first colum to 0. User will only see the Name.

    For the first and last name see <A target="_blank" HREF=http://www.wopr.com/cgi-bin/w3t/showthreaded.pl?Cat=&Board=acc&Number=98159&page=& view=&sb=&o=&vc=1#Post98159>This post</A>
    Francois

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •