Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2006
    Posts
    7

    Unanswered: form field values from another table

    Hi everyone,

    I have the following 3 tables

    Stations :many to one to --> Departments :indetermined to -- > Sites (site #, site name, site address)

    There is a data-entry form for table 'stations' that acquire information from a user including department code (combo box, values taken from a field in table 'departments', going to the field 'department' in table 'stations' ).

    Here is what's needed:

    a field on the same form that will display related site name and address as soon as the user enters department name via combo box .


    Can anybody help ? will appreciate the response

    Thanx

  2. #2
    Join Date
    Apr 2004
    Location
    metro Detroit
    Posts
    634
    Try either a DLookup or a query depending on the number of recodrs in the Sites table and if you want the Site table information to be editable or read only.

Posting Permissions

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