Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Automarking with 2 relational browse boxes

Status
Not open for further replies.

benny4129

Programmer
Jan 19, 2007
12
US
Hi All

I am using Clarion 5.5 Enterprise with Windows XP Home Edition. I have created 2 browse boxes on the same (ABC)browse procedure. The left hand browse is a Payee file display and the right browse is the Account files related to the Payee record.

PAY:payeeNumber with a 1:many relation to ACC:payeeNumber
ACC:AccountNo

I want to automark all related payee accounts that are within 5 days of the Account duedate by clicking a push button on the browse procedure.
All I need to know is how to do the auto process selection of the browse boxes.

These are the steps to explain in detail what I need.

Steps 1. I click on Automark button in the browse procedure
2. Autmark button's accept event excutes remaining steps
3. Select first Payee record in Payee browsebox
4. Select first Account record related to Payee
5. Do Automarking Routine(marking code already worked out)
6. Select next Account
7. Do Automarking Routine
8. Do rest of related Account records for the selected Payee
9. Select next Payee
10. Process related Accounts
11. Process all records until end of Payee file
12. Process last Payee's related Accounts
13. End Process

I thank you in advance for any help
 
Hi Benny,

You have not mentioned your Marking process i.e. are you using a 3rd party product to do marking or have you just use the marking feature of the List Box?

Assuming the latter, since the List Box is fed by a Queue and has a Mark column which is set to True/False (1/0) when marked/unmarked. So, just run through the List Box queue and set the Mark to True for all the entries that meet the criteria.

Regards
 
Thank you for your reply ShankarJ

It is all written in a very detailed source code and stored in a marker routine. The best way for you to understand what I am talking about is for you to let me email the HTML Help file I created for the program. It shows and explains in detail what the marking feature does and how it affects the program. All I need to know is how to cycle through Payee records and do the Marker routine for each related Account record. I would like for the selector bars to show the selection of each Payee and each Account record as they are being processed. I hope this explains what I want to do so you can understand it.

Thanks Benny4129
 
Hi Benny,

You can e-mail me at j s h a n k a r @ e i m . a e.

But I would prefer the generated source code to the HTML help file as it would not help me understand the process logic. To get the generated source, open the procedure, go to Embeds and choose Filled. This will show the Generated source and you can copy & paste into a text file. The other option is the module view option when you right-click on a procedure in the Procedure Tree of the application.

Regards
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top