Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2010
    Posts
    6

    Unanswered: Display record in unbound text field on form

    HI...

    I have two table
    1.Equipment
    i.ID
    ii.Name
    2.History
    i.ID
    ii.Job

    Equipment [ID] and History [ID] are linked with primary key....

    Now i have a form containing History table fields

    The problem is ;

    on History Form , i also want to display Name field from Equipment table having Equipment [ID]which is matched with showing History [ID] field.... how to do that in easiest way.... hope you under stand my problem....

  2. #2
    Join Date
    Aug 2004
    Location
    Cary, NC
    Posts
    264
    1. Create a query that joins those two tables and shows you the fields that you want to see
    2. Use this query as the Record Source for the form
    3. Add new fields to the form

    Steve

  3. #3
    Join Date
    Jun 2010
    Posts
    6
    dear....

    kindly send me code, i am new to ms access ... dont know how....

    regards

Posting Permissions

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