Hi Peggers.
MFG/Pro 8.6e progress 8.3a04
here we go. I am writting a new business report. This report consists of new items sold to a customer for during the current month. I have built a database that I connect to my production database that contains data for the customer and product, when they entered the program for the part and how long they will be monitored for. one stipulation is that th customer must not have bought the part within the past 18 months. The first thing I do is read the ih_hist and idh_hist to get the invoices for the month. Then I compare them to my new business file to see if they are already on the program. This part works fine. The next step is confusing me now. At this point, I need to go back and read the idh_hist for custoler/part that are not in the program to see if the part was purchased over the last 18 months. Can I go back and search through the idh_hist, or do I need to create a temp table to write my initial "good" records to? Can I just fo a find to see of a record exi!
sts in the 18 month period? Does anyone understand wat I'm asking, because I'm kinda doubtfull that I understand me. Please help, Thanks.
David L. Knowles
Database Administrator
Captive Plastics, Inc
Partners in Plastics Packaging
MFG/Pro 8.6e progress 8.3a04
here we go. I am writting a new business report. This report consists of new items sold to a customer for during the current month. I have built a database that I connect to my production database that contains data for the customer and product, when they entered the program for the part and how long they will be monitored for. one stipulation is that th customer must not have bought the part within the past 18 months. The first thing I do is read the ih_hist and idh_hist to get the invoices for the month. Then I compare them to my new business file to see if they are already on the program. This part works fine. The next step is confusing me now. At this point, I need to go back and read the idh_hist for custoler/part that are not in the program to see if the part was purchased over the last 18 months. Can I go back and search through the idh_hist, or do I need to create a temp table to write my initial "good" records to? Can I just fo a find to see of a record exi!
sts in the 18 month period? Does anyone understand wat I'm asking, because I'm kinda doubtfull that I understand me. Please help, Thanks.
David L. Knowles
Database Administrator
Captive Plastics, Inc
Partners in Plastics Packaging