Title
Looking for a Directionn
Post
Phil,
In Quoter database we quote specific machines to customers. In each quote we record a stock number, make, model, description, serial number of each machine we quote. We may, and do, quote the same machine to many times but to difference customers.
The direction I am looking for is How can I set up a layout that would show mw a history of how many time a particualr machine was quoted. I would like the layout to show one line summary for each customer with the quote date, etc of each time this machine was quoted.
Just point me in a direction of how I can design this machine history layout.
Thanks, Jeff
Create this field in Machines--not quotes. There's a fundamental difference in the original table and relationship designs that I posted and that you posted. I'm assuming that Machines in your post is the same as LineItems in my post--a record that records a single quote about a single machine. If this is not the case, let me know and disregard the following.
Your script performed by your button would look like this:
Set variable[$Serial ; value: Machines::SerialNumberField]
Set variable[$Model ; value: Machines::ModelNumberField]
Go to layout ["HistoryReport" (Machines)]
Enter Find mode [] //clear the pause check box
Set field [Machines::SerialNumberField ; $Serial ]
Set Field [Machines::ModelNumberField ; $Model ]
Set Error capture [on]
Perform Find []
Sort [restore ; no dialog]