Updating related info

[mdurg]

Hi there, I'm looking for some basic info for updating related info. I'm using CDML and the standard "NEW" format file to enter information to the Filemaker database. I have a drop down value list for our outside guys to choose a customer by name (working fine). Now, once they make that choice I'd like that to pull related information such as address, city, state and zip from the related customer file. Fill in the blanks so to speak.

So what I'm guessing is that on selection of customer, a new record gets created with the customer name and related information being served back in an "EDIT" page. I've got the javascript down, but I don't know how to come up with the proper URL and how to give that to Filemaker.

Am I on the right track? Any help is greatly appreciated!

Thanks,

Mark Durgee

[Garry Claridge]

The way I have done this before is to have a list of Customers (on a page) the user clicks on the Customer name then the new edit page is displayed with the Customer details.

You can use the <select> "onchange()" event, and "-new", to achieve the same effect.

On the FM Layout have the related fields and just fill-in the Customer values, in the Format file, with [FMP-Field:myrelationship::cust_name] etc.

All the best.

Garry