malagasy Posted January 2, 2007 Share Posted January 2, 2007 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 More sharing options...
agtjazz Posted January 2, 2007 Share Posted January 2, 2007 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 More sharing options...
Recommended Posts
This topic is 6324 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 accountSign in
Already have an account? Sign in here.
Sign In Now