Jump to content

Create a new order ?


This topic is 5751 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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.

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

This topic is 5751 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.