Display Customer details on the header of an Order Master Display

Applications Forms
#1

Dear Sir/Madam,

We are new at using Scriptcase. We have created a form, master/detail for orders.
Since each order is made by an existing customer. It is logical to display delivery
address, contact information for that particular order on the header of the form.

Is there documentation on how to display it on the master, which is the order master?
We dont want to open another form or page to see it. maybe a tab will do but we
prefer to see in one page, which is on the header of the order As shown below.

Order Header

Order number : 2012-0099 Customer Code: CU000021 (in the Order Table)
Date Ordered: MM-DD-YYYY Customer Name: (Customer Table linked via CustCode)
Sales Person: John Doe Delivery Address: (Customer Table Field)
Estimated Delivery Date: MM DD YYY Contact Person: (Customer Table Field)
Order Total: 9999999

Order Detail

Qty. Unit Description Unit Price Sub-Total

We would appreciate your help on this matter.

Best regards,

Irabelle

#2

Re: Display Customer details on the header of an Order Master Display

Hi,
have a look at the samples base.

http://www.scriptcase.net/phpgenerator/samples/tutoriais/form/form38.php

This one should point you in the right direction.

jsb

#3

Re: Display Customer details on the header of an Order Master Display

Hi JSB,

We tried the solution but we are only able to display one file from the customer table. Only the customer name, we need to display the shipping address and other information connected to the customer who made the order on the order master detail form. when we try to add other fields from the customer table on “SELECT” it does not display anything.

Do we need to make an AJAX command or an event or both?

Kindly give further information.

Best regards,

Irabelle

#4

Re: Display Customer details on the header of an Order Master Display

Hi,
I suppose that your master is based on your order table and want to “import” those fields from your customer table.
In this case you have to create (all) those form fields under “Fields”–>“New Field” and use the “Grid Lookup” feature from the field settings to get the values for each of those fields.

jsb