Oh okay. I am with you. It depends on what you need the user to see or do. Dan Goldberg
From: [email protected] [mailto:[email protected]] On Behalf Of Karen Tellef Sent: Monday, December 21, 2015 4:11 PM To: Dan Goldberg Subject: [RBASE-L] - Re: DB Grid vs Scrolling region with DB Edits Sorry Dan, I didn't explain what I meant by lookups. Yes you can display lookup values in place of column data (like a client name instead of the column ClientID). But unless something's changed you can't include a lookup of something that isn't in the table. For example if I have a row of data from a Sales table, but I also want to show lookups of data from other tables, like maybe the amount of overdue invoices from another table or the most-often purchased item in the past year... stuff like that. For that I would use a scrolling region so I could define a form variable and display it on every row. Karen -----Original Message----- From: Dan Goldberg <[email protected]<mailto:[email protected]>> To: karentellef <[email protected]<mailto:[email protected]>> Sent: Mon, Dec 21, 2015 12:24 pm Subject: [RBASE-L] - Re: DB Grid vs Scrolling region with DB Edits I try to use enhanced dbgrids as much as possible. They seem to run faster for me and you can use the filter easily. BTW, you can do lookups and expressions on enhanced dbgrids. Dan Goldberg From: [email protected]<mailto:[email protected]> [mailto:[email protected]<mailto:[email protected]?>] On Behalf Of Karen Tellef Sent: Monday, December 21, 2015 6:10 AM To: Dan Goldberg Subject: [RBASE-L] - Re: DB Grid vs Scrolling region with DB Edits That's a toughy Mike, and I run into that dilemma all the time.. IMO the DBGrid "looks" more windows-like and I use it all the time for simple things like maintenance of lookup-type of tables. However, if I have to display lookup data on the form for each row (like the names of clients or items, or other lookup type of data) I find scrolling regions the way to go. So to me, it's just one question: do I have to display lookups or not. Others might speak to whether the performance is the same on both, I have no clue.... Karen -----Original Message----- From: Michael J. Sinclair <[email protected]<mailto:[email protected]>> To: karentellef <[email protected]<mailto:[email protected]>> Sent: Sun, Dec 20, 2015 8:25 pm Subject: [RBASE-L] - DB Grid vs Scrolling region with DB Edits Hi All, I want to create a form with multiple tables. I think I can do it two different ways, ie 1 DB Grid object per table and select the desired columns, vs 1 scrolling region per table and place the columns I want using DB Editobjects on the scrolling regions. Is there a preferred method? Using the Scrolling regions seems to give me more flexibility but might take me longer. Should they both perform equally well? Mike
