AnsweredAssumed Answered

Getting additional data from related table?

Question asked by pauhana658 on Jul 20, 2012
Latest reply on Jul 21, 2012 by philmodjunk

Title

Getting additional data from related table?

Post

Back again with yet another simple question with an obvious answer that everyone but me knows.

 

I have an Invoices table layout with a portal that displays related records from the Invoice Details table. This portal contains a popup populated with data from a related Rates table. Selecting a category from this popup fills in the category field in the related Invoice Details record. All well and good. 

But the Rates table also contains other data that I want to have automatically added to the Invoice Details record, so that selecting a category automatically fills in the Rate and Unit associated with that category.

I tried using the following script (attached to the Category popup) which, aside from the last line, doesn't work. Perhaps someone can tell me why and what I need to do to fix it?

Set Field [Invoice Details::Rate; Invoice Details::Rate = Rates::Rate]

Set Field [Invoice Details::Unit; Invoice Details::Unit = Rates::Unit]

Go to Field [Invoice Details::Count]

 

Thanks! (no, this is not the last line of the script!)

 

Screen_Shot_2012-07-20_at_21.29.29.png

Outcomes