2 Replies Latest reply on Nov 14, 2011 8:33 AM by philmodjunk

    display several different related records on same layout

    GerryTucker

      Title

      display several different related records on same layout

      Post

      I'm a truck driver designing a database for my trucking jobs. I have two related tables: "Jobs" and "Contacts". I have a layout for jobs, and need to display several stops for each job on this layout. Each stop is at a location of one of the Contacts. I want to display the fields "company name" and "city" and "state" for each stop based on an ID for each contact. I can't get it to display any more than the first one. Do I need to have another separate table for "Stops", and relate it to the "Jobs" table? I'm getting dizzy trying to figure this out.