Re: Click Table (Jim Ault)

2007-02-23 Thread John Runde

Thanks for your reply, Jim.

I also may not have explained what I need very well.

All i want to do is have a table where i can click on an item
and identify the line & item# that was clicked on, and can drill down  
for the user for the details on that item.


For example, a monthly financial report:

Column 1 (item 1) would hav categories (of revenue...say)
Row 1 (line 1) would have the months of the  year, starting with  
column 2... 12 months (Jan, FebDec)


(you can see that line 1, item 1 would not be used)

I would then fill that grid with the summary of revenue data for the  
monthly report
User wants to see why category "Misc Revenue" was so high in July,  
Misc Revenue is line 10, July is column 8 (item 8)

He/she clicks on that number.
click populates cell 1,1 with "10,8"
I then have code that goes puts the category (item 1 of line 10) into  
"theCategory"

   and the month (item 8 of line 1) into "theMonth"
code then goes to the source document and finds all the entries for  
theCategory that originated in month theMonth

I then pop up a stub stack and populate it with those transactions.

Real simple.  I can't believe it is as hard as it is, unless I am  
missing something.
(did it in hypercard all the time by aligning the report and getting  
the clickword, then checking for a sign).

But a table field would (if it worked) be much better.


Thanks,
john
___
use-revolution mailing list
use-revolution@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution


Click Table

2007-02-22 Thread John Runde
I am doing some financial programming.  Of prime importance, is a a  
Spreadsheet like field... I will call a "click field".  It is a  
crucial piece of my project, and I have not been able to get it to  
work.  Note that I am an accountant, not a programmer (but an old  
hand at hypercard).


Here are the criteria I need:

1. a table field
2. the field is locked
3.  when you click on a cell, the row, column (item,line), should be  
placed in the top, leftmost cell (i.e. "1,1").  This cell will be  
reserved for this purpose.

4.  the table should scroll both H and V
5.  I should be able to resize the table as needed (for various cards).
6.  I will use code to populate the click field, it would be nice if  
the field would auto adjust for column width.


This seems so simple, yet I cannot get it to work.  It has to have  
something to do with properties, but danged if I can figure out  
what.  I tried about every property setting in combination, but to no  
avail.


Can someone program the above and either email it to me, or give me  
the details.


email "[EMAIL PROTECTED]"

Many Thanks to any who will help,
jwr
___
use-revolution mailing list
use-revolution@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution