Using FM8.5 advanced on Win XPpro. I have a database called dashboard which
contains tables 'startup' and others (unrelated to the issue). The startup
table contains mostly 'who am i' type data including the employee ID. There
is a file reference to another database called assignments which is a
listing of all sales assignments which have not been commissioned.
The main (initial) screen shows some summary information for the user and a
listing of 'pending' sales. This listing shows only basic information about
each sales assignment (including the sale number) and is presented in a
portal via a relationship where emp_id in dashboard = emp_id in assignments.
Works like a breeze.
What I want to do is to create an assignment detail screen which would
display all of the details for a particular sales record. When the user
clicks on the sale number a script is called to change to that layout.
Problem is that the sale number on the detail screen is not the same one
that was clicked. I tried creating another relationship into a second copy
of assignments (assignment detail) on the sale number but that did not work
either. Then I tried storing the sale number to a variable and doing a find.
No luck there either. The sale number displayed is always the first one in
the assignments table.
Is there a way to do this? Seems like pretty basic design requirements to
me.
