U
user3145218
Guest
I am using OS - Windows 7, technology - progess 4gl. I have two tables customer and order. I am displaying customer details along with their orders. Each customer may have more then one order. The report should be as below
CUSTOMER:- CUMTOMER NAME ADDRESS CUSTOMER1 XYZ ORDER1 OF CUSTOMER1:- ORDER NO. ORDER DETAILS 1 ASD 2 ASDFGGH 3 FGHJFG /* IT SHOULD REPEAT FOR THE PARTICULAR CUTOMER */
CUSTOMER2 ABC ORDER1 OF CUSTOMER1:- ORDER NO. ORDER DETAILS 1 ZXC 2 VNVN 3 JJLK
I Think for this we need one-many relationship between customer and order table. I have only customer and order temp-tables for doing this.Can you please tell me How to repeat the loop inside customer and how to link the tables in one-many relationship. Thanks in advance.
Continue reading...
CUSTOMER:- CUMTOMER NAME ADDRESS CUSTOMER1 XYZ ORDER1 OF CUSTOMER1:- ORDER NO. ORDER DETAILS 1 ASD 2 ASDFGGH 3 FGHJFG /* IT SHOULD REPEAT FOR THE PARTICULAR CUTOMER */
CUSTOMER2 ABC ORDER1 OF CUSTOMER1:- ORDER NO. ORDER DETAILS 1 ZXC 2 VNVN 3 JJLK
I Think for this we need one-many relationship between customer and order table. I have only customer and order temp-tables for doing this.Can you please tell me How to repeat the loop inside customer and how to link the tables in one-many relationship. Thanks in advance.
Continue reading...