Create a new order ?

[malagasy]

Hi everyone,

First, HAPPY NEW YEAR 2007

I'm really bad at scripting. I don't really know much of their uses, etc...

I have a database with several Tables. In this case, I have a Customer table, an Order table and a Product table.

What I'm trying to do (and fail) is having a button in the Customer Layout that will allow me to go in a new window and create a new order with the info of the customer such as his name, id, without me having to reenter these data manually on my order layout...

What script should I use ?

Any relationship?

Thanks.

[agtjazz]

Hello & Happy New Year

If relationships have already been created, you could:

Set a global field to the customer_ID

Go to layout based on Orders table occurrence

New record

Set foreign customer_ID field in Orders to value in global field

His name and address etc should all come thru via relationships.

Hope that helps.