Professional Web Applications Themes

go to a related record - Microsoft Access

Does anyone know how I go to the related record in another table without manually opening the table and searching for ID5. Is there a way of setting up a button to go directly to the details relating to that employee in the contract table? Eg I have details for employee ID5 in the employee table and I want to view the contract details of that employee in the contracts table Is there an easy solution without getting heavily into visual basic?...

  1. #1

    Default go to a related record

    Does anyone know how I go to the related record in another
    table without manually opening the table and searching for
    ID5. Is there a way of setting up a button to go directly
    to the details relating to that employee in the contract
    table?
    Eg I have details for employee ID5 in the employee table
    and I want to view the contract details of that employee
    in the contracts table

    Is there an easy solution without getting heavily into
    visual basic?


    Lynn Guest

  2. #2

    Default go to a related record



    If u are using a form to display the data, go to design
    view of the form displaying 'employee table data'. create
    a button. when the wizard opens, select 'Form operations'
    from categories and 'Open Form' from actions. hit next.
    select form showing details of contract table. hit next.
    Choose 'open the form and find specific data to display'.
    hit next. match up the two fields containing employee ID,
    hit next and your done. wizards all the way!
    Simon Guest

  3. #3

    Default go to a related record

    Thanks very much for the useful info. I have used it
    already! 
    lynn Guest

Similar Threads

  1. Goto related portal record.
    By Toade in forum FileMaker
    Replies: 4
    Last Post: December 8th, 02:50 AM
  2. Sort related record/SLOOOOOOW
    By Zsah in forum FileMaker
    Replies: 7
    Last Post: October 29th, 08:24 PM
  3. go to related record in many-many on web
    By Sleepy in forum FileMaker
    Replies: 5
    Last Post: September 10th, 11:29 PM
  4. Go to Related Record in Instant Web Publishing
    By Tim Booth in forum FileMaker
    Replies: 1
    Last Post: August 26th, 04:04 PM
  5. Go to related record creates new record?
    By Project Mayhem in forum FileMaker
    Replies: 3
    Last Post: July 29th, 07:02 AM

Bookmarks

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139