January 2, 200719 yr 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.
January 2, 200719 yr 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.
Create an account or sign in to comment