Client: 213W Wine Imports

Project: Custom FileMaker Pro Database System

Subject: Build x08

Date: 8/01/2011

There is 1 agenda items addressed in this Build x08 . . .

1. SALES ORDER FORM DOES NOT ALWAYS DISPLAY CORRECT CUSTOMER

1.1 Issue.

(Frank) ". . . i notice that the invoice now functions with the <packing slip> and the <order> buttons. however when i make the second new record and try to use these buttons, the line fields show up correctly, but the address in the header does not update, and the total, subtotal and tax in the trailing grand summary is all from the first record. this continues no matter what record i generate, the first records is present, but the line items are correct. i looked at the scripts for the <packing slip> and the <order> buttons and see that the line items are correct, but there is no way for the ORDER table to be updated. is there an easy fix for this? this is important since i can not proceed without this function . . ."

1.2 Problem.

The routine to View, Print, and Email a Sales Order Form or a Packing Slip Form uses a button on the Sales Order (Detail View) screen to run a Script to display another Layout designed as the respective form as a new popup window. The Script uses a script step [Go to Related Record] with a table occurance different than the Table Occurance assigned to these Layouts for the forms.

1.3 Correction.

I re-assign the table occurance for the 2 new layouts to match the table occurance assignedin the [Go to related record] script step. I also changed the fields in the body part on the layouts to the re-assigned table occurance. I also revised the script step to open the new window with values for the title for the new window title bar, the width and height for the window, and to be positions slightly below and centered on top of the main screen of the database.

1.4 Screenshots.

1) REVISED "Popup" WINDOW (Title, Width, Height, and Position)

2) MANAGE LAYOUTS (re-assigned Table Occurances for FORMS Layouts)

3) LAYOUT SETUP (revised Table Occurance in "Show record from:" selection)

4) REVISED SCRIPT for New "Popup" Windows for SALES ORDER FORM

5) WINDOW SETTINGS (for Title, Height, Width, Position)