Button to Sort and view certain records.

[justinltaylor]

Hello again filemakers,

I have 2 tables one has contact data and the other has job data. They are related by a serial customer id number. I have already made a button that users can click and create a new job. Now i need to make a button that will allow them to view only the jobs for the customer they are looking at. So if i'm looking at my customer the Poop Bank, i want to have a button that will take me to the other table and display only the jobs that were made for the Poop Bank.

Here's the script i have tried so far but it's not working:

Go to Layout ["Billing Entry" (Billing Entry)]

Set Variable [$ID; Value:Contacts::Customer ID]

Enter Find Mode[]

Perform Find [Restore]

Exit Script []

That will pull up the correct jobs if the customer i'm looking for was the last one i created a job for. If i try to go to a different customer it will continue to pull up the same customer as with the first find.

Is it not putting new data in the variable?

Thanks

Taylor

[LaRetta]

pretty close! Grab the customer ID while still on the customer layout where the button exists...

Set Variable [$ID; Value:Contacts::Customer ID]

Go to Layout ["Billing Entry" (Billing Entry)]

Enter Find Mode[]. <------- remove this line as unnecessary

Set Error Capture [ on ]

Perform Find [Restore] <----- the restore should select BillingEntry::CustomerID and put $ID as the value

If [ not Get ( FoundCount ) ]

Show custom dialog [ no records found ]

Go to layout [ original layout ]

Exit Script []

End If

[justinltaylor]

Thanks LaRetta That was exactly what the problem was.