AnsweredAssumed Answered

display several different related records on same layout

Question asked by GerryTucker on Nov 13, 2011
Latest reply on Nov 14, 2011 by philmodjunk

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.

Outcomes