AnsweredAssumed Answered

relationship problem...and i dont mean with my wife

Question asked by beaglepro on Jan 15, 2010
Latest reply on Jan 18, 2010 by philmodjunk

Title

relationship problem...and i dont mean with my wife

Post

I have three tables, Contacts, Timesheet, Quotes.

 

When i am filling out the timesheet, I want to be be able to select a quote ,which i do via a values list. Then i want a field to populate the contact from the Quote table. Quote contacts are populated from the Contacts table.

This works ok for the first line, using look ups but every line under just populates with the result of the first line. I want the contact to change on every line change when the quote has changed.

I have been using sperate fields for the quote, and contact s per line, ie not using repetitions as i dont know how to aggregate/report these.

 

 Any help please.

Outcomes