Drew Wutka
DWUTKA at Marlow.com
Mon Sep 13 17:29:07 CDT 2010
You weren't really using the second method. When I build a database, one of my underlying ideologies is that there is rarely a good reason to CHANGE data. This is not something I enforce in a Nazi like manner, rather it is a concept that I build into the system so the user doesn't even have to notice. Some examples: -When the price of an item goes from $1.55 to $2.17, that isn't a change in data, it's additional data. Yesterday it cost $1.55, TODAY it costs $2.17. So that should be reflected in the data design. -When you add 10 items to your inventory, that's not just a change in the inventory level, it's a transaction. Yes, you can do one too many with subforms. Bound/unbound is more preference, then science. Personally, I prefer to build my business logic into a class structure. Treating data as relevant objects, not just records. That way, it doesn't really matter what interface I use. Drew -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Stuart McLachlan Sent: Monday, September 13, 2010 4:03 PM To: Access Developers discussion and problem solving Subject: Re: [AccessD] The Famous Bound/Unbound Debate But, but, but..... I commonly use the second method in a bound sub-form. Does than make mean I'm not a bounder after all? D*mn, all this time, I thought I was a died-in-the-wool bounder. -- Stuart On 13 Sep 2010 at 14:42, Drew Wutka wrote: > JC just brought up his 'call center' application, and a while back, we > had a discussion about one element of that application. > > It was in a 'memo' field. Let's say we had to track calls coming in > to a support center. We'd have fields for caller, tech, date, time, > issue, categories, etc. And a memo field for details not put into > more specific fields. > > In a bound method, that memo field would be just that, one field, in a > table. So as notes are 'added' to a ticket, you are modifying one > field, in one record. > > In an unbound method, that memo field would be a separate table, with > an ID field linking back to the original table. Each entry would be > timestamped (and stamped with the creator of the record). You > wouldn't edit a 'comment', simply add a new entry. > > There are pros and cons to both methods. > > Drew > > -----Original Message----- > From: accessd-bounces at databaseadvisors.com > [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Brad Marks > Sent: Monday, September 13, 2010 2:03 PM To: Access Developers > discussion and problem solving Subject: [AccessD] The Famous > Bound/Unbound Debate > > All, > > Compared to most of you, I am a relative newcomer to the world of > Access. > > Over the past few months, I have noticed a number of references to the > Bound/Unbound debate. It sounds like this was a really hotly > contested issue at one time and that now people almost joke about it. > > For us newcomers, it would be nice if someone could explain this issue > at a high level and perhaps spell out the major pros and cons of each > side of the debate. > > It is not my intent to start a Web-war, I would just like to better > understand what is going on here. > > Thanks, > Brad > The information contained in this transmission is intended only for > the person or entity to which it is addressed and may contain II-VI > Proprietary and/or II-VI Business Sensitive material. If you are not > the intended recipient, please contact the sender immediately and > destroy the material in its entirety, whether electronic or hard copy. > You are notified that any review, retransmission, copying, disclosure, > dissemination, or other use of, or taking of any action in reliance > upon this information by persons or entities other than the intended > recipient is prohibited. > > > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com > -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com The information contained in this transmission is intended only for the person or entity to which it is addressed and may contain II-VI Proprietary and/or II-VI Business Sensitive material. If you are not the intended recipient, please contact the sender immediately and destroy the material in its entirety, whether electronic or hard copy. You are notified that any review, retransmission, copying, disclosure, dissemination, or other use of, or taking of any action in reliance upon this information by persons or entities other than the intended recipient is prohibited.