Pl look at the attached database. My basic aim is to print the the record in form of annexure or invoice. Refer to form Main. It has different fields. When user fill the record and clicks on "Print Annexure" it should print the record which the user is standing on. Refer to record 6 for example .There are multiple items with quantity for e.g. Masalimine with qty = 25 and Saxagliptin 2.5 with qty 20. This record has 2 items only but some may have more then that. When user prints Annexure which is a report, items should get populated as they are ( 2 or 3 or more) and also the quantity So it should be Masalimine 25 Saxagliptin 2.5 20.
Also instead of primary key, field value in Item should come on the report.
I will then add the other fields on the Main Form to the report.
Let me know if you require any further clearification
Thanks for your help
8/22/2022 - Mon
All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat