I guess another option could be a portal in the BillingBatches table with a window to the Billing Packets... that is one option I totally missed out...
The issue with using a portal is we have a search function on that Billing Packets view that does like a "Hyper Search". You know Search as you type... So if put a portal as the view can you do these types of searches in the portal?
Well after talking to some management we decided not to go this route. But if anyone does have idea on how to create something like this I would still like to hear it...
It's a bit hard to picture what you are describing.
I think you have two tables involved: BillingBatches and BillingPackets with a one to many relationship based on Batch#.
That would give you a relationship that looks like BillingBatches:: Batch# = BillingPackets:: Batch#.
I think you are wanting to step through the different groups of BillingPackets records following the order of BillingBatches records in your current found set.
If so, this is easy to do. You can use a scripted find or Go To Related Record for this.
Here's the scripted find approach to move to the Next batch. Simple changes to this script will allow you to move to the previous batch.
Go To Layout [BillingBatches]
Go To record [next]
Set Variable [$Batch ; Value BillingBatches::Batch#]
Go to Layout [BilingPackets]
Enter Find Mode
Set Field [BillingPackets::Batch# ; $Batch]
Set Error Capture [on]
Sort [Restore ; No Dialog ]
Change line two to Go To Record [Previous] and you have a script for pulling up the previous batch. If you reach the end of the list of batches, this script flashes the screen and keeps the same list up. You can modify this script to detect this situation and pop up a custom dialog if you wish.
thanks for the reply. You understood me all the way! I will give it a try and let you know if it works. There will not be any problems because I am moving from the Billing Batches Table to the Billing Packets table?
Every layout is linked to a table occurrence box on your relationship graph. That's controlled by the table occurrence selected in the "Show Records from" box in Layout Setup...
Every table occurrence has it's own found set and current record. Switching from layout to layout will not change these. Performing sorts and finds on another layout will not change the records shown on other layouts unless that layout refers to the same table occurrence.
Sometimes I define an extra table occurrence to the same table just so I can juggle two different found sets for the same table, freezing the window and switching back and forth between the layouts, all hidden from the user.