thulli Posted November 10, 2004 Posted November 10, 2004 I've an Order table with several Lines related to it. A Line belongs to an Order by using a relationship. I would like to make a print of this Order. I tried with a layout related to Order with 3 parts : header, body and footer. In header is all the information about the order (customer name, order number etc). In the body I want to see all the Lines related to this Order. I want this body to grow with the number of Lines. The footer contains the total price, rebates etc... This is really basic but it's not easy to do. But I'm unable to get that. Can you tell me how to do that? Thank you for your help
Vaughan Posted November 10, 2004 Posted November 10, 2004 You do this kind of report from the *related* file. Use the Go to Related Record [show, relationship ] script step to find all the related records that match the current record, then change to the related file. Build a layout in the related file with a Leading Grand Summary that contains all the oder information (this will be brought in through a relationship back to the Orders database). Each Line record goes into the body of the layout.
thulli Posted November 11, 2004 Author Posted November 11, 2004 Thank you for your help! It was reaaly helpful!
Recommended Posts
This topic is 7318 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