Interesting idea to hide tabs and have buttons to display, that would be close to the way their DOS system is designed. If I did this, I suppose they could click to go to "payments", which would hide "sales", and then by clicking "sales" I could refresh that table before redisplay....
Karen -----Original Message----- From: MikeB <[email protected]> To: karentellef <[email protected]> Sent: Tue, Aug 25, 2015 10:43 am Subject: [RBASE-L] - Re: Need help with multi-tab form If I need a lot of flexibility on a tabbed setup, I hide the tabs on startup and place buttons of my choice on an enhanced panel wherever (relative to the tabbed control) and choose which tab panel to expose based on button click and the activepageindex to display the panel. This gives you the opportunity to get to some middle ground away from either a source or target control to examine conditions (variables, controls, etc) to choose the pathway from there. You might consider setting a bit flag (text variable value or something) on first entry to the one form and then change it concurrent with the acceptance of the data by the user, which you could then react on moving to the next panel based on whatever the value was. > -----Original Message----- > From: [email protected] [mailto:[email protected]] On Behalf Of Albert > Sent: Tuesday, August 25, 2015 11:09 AM > To: [email protected] > Subject: [RBASE-L] - Re: Need help with multi-tab form > > Karen, > > Can you set focus on arrival in the sales table tab to the field to be > updated, and then run the calculation in an on entry eep? > > Albert > > > On 2015-08-25 8:32 AM, Karen Tellef wrote: > > > My dilemna: very old (1980s) RBase database, designed by someone > other than me. Not very relational in that there is a Sales table and > a Payments table, but there is a column called TotalPayments in the > Sales table that has a total of the payments so that a computed column > Balance can be calculated. > > In the DOS system, there is a separate form for Payments, so on > closing that form it's very easy to compute the total payments and > update the Sales table before bringing the Sales form back up. > > In 9.5, they LOVE the idea of a form with multiple tabs, so I > have Sales on tab 1, and Payments on tab 2. > > Here's what works: If you're in Payments, I have an "on row > save" eep so that if they change the amount it sums the payments, > updates the Sales table and refreshes the Sales table. So if you save > the row and then click back into tab 1, viola it's there. > > What doesn't work: If you change a Payment amount and, while > still in that row, click to tab 1, your row is not yet saved so nothing > has been changed. I can see that if I then physically click into a > Sales field on tab 1, it then saves my payments and does a refresh. > But just clicking on the tab 1 header does not save the data. > I tried putting identical code in the "on leave section" > of Payments, but that does not evaluate if you click to another tab or > even if you [esc] out of the form. > > I know I can do something like trap the payment going into the > field, trap it going out of the field, and if it's different than do a > "saverow", but that takes away the ability of the user to change their > mind about the change. > What I also tried: I can do a "change tab eep" on tab 1 so that > it puts focus into a Sales field. That works cuz it forces a save. > Only issue is that this client worries about people making inadvertent > changes so they don't want them put "into" the data unless they click. > So unless I add a "dummy" field into the table..... > > Any other ideas? > > Karen > > >
