Recent content by Alico

  1. A

    Avoid multiple entry for foreign key

    Hi All, I have a master to child table relation which is one to many. Each one is represented by a different form. The problem is, the user enters the primary key "JobID" on the master form, then he needs to enter a few records on the child list with the same "JobID" which is the foreign key...
  2. A

    Problem with table relationships - Foreign Key and Primary Key

    Hi, My application is a series of checklists, represented each by a table. They all have a common "Job ID" which is entered by the user in the first form/table. This "Job ID" is a common value with all other tables. What I want, is that the user doesn't have to enter the "Job ID" every in...
Back
Top Bottom