I added the JobHead as a FKV and then added the JobOper as a Sub-Table view.
________________________________
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Ken Williams
Sent: Friday, February 10, 2012 10:36 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Tricky Foreign Key View
I'm trying to get JobOper.QtyCompleted and JobOper.QtyPer added to the End Activity screen. It would serve as reminders of the quantity required and previous quantity completed for our jobs.
Going into it I thought, simple, FKV and I'm done.
However, I can't seem to get to the JobOper table from the options. The trick is that I need both the JobNum & OprSeq from the "End" table passed through on the FKV, but I can't seem to select two fields to push. I'm assuming this is done through a multi-key view, but I can't seem to figure out the details of that either....
Any suggestions on how to make this view work?
Ken
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
________________________________
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Ken Williams
Sent: Friday, February 10, 2012 10:36 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Tricky Foreign Key View
I'm trying to get JobOper.QtyCompleted and JobOper.QtyPer added to the End Activity screen. It would serve as reminders of the quantity required and previous quantity completed for our jobs.
Going into it I thought, simple, FKV and I'm done.
However, I can't seem to get to the JobOper table from the options. The trick is that I need both the JobNum & OprSeq from the "End" table passed through on the FKV, but I can't seem to select two fields to push. I'm assuming this is done through a multi-key view, but I can't seem to figure out the details of that either....
Any suggestions on how to make this view work?
Ken
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]