Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2003

    Red face Unanswered: I wanna link a form with multiple tables

    hi guys,

    this is kinda urgent what i am trying to do is that i want to link a combo to a text box where the text box selects the right designation of the employee from the employees table depending on the name of the employee that has been chosen in the combo box...both these fields belong to different tables and are to be stored in a new table that is designation, along with some new fields that have been entered by the employee in the form.

    anybody's got any clue how to do this.

    Thanks and Regards,

  2. #2
    Join Date
    Sep 2003
    this is quite easy:

    create a query that contains all the tables and fields you need. make sure you have key fields that will link all tables to avoid multiple rows of each record. now select the query instead of a table in your option field.

    hope that helped ;-)

Posting Permissions

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