Getting additional data from related table?
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!)