jwcolby
jwcolby at colbyconsulting.com
Wed Sep 26 09:51:32 CDT 2007
Yep. And what is with the ----------------------------------------> thing? Your email is the only one I am seeing this on. Is this your attempt to FORCE users to snip old stuff? ;-) John W. Colby Colby Consulting www.ColbyConsulting.com -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Mark A Matte Sent: Wednesday, September 26, 2007 10:38 AM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Mucking around I meant if you had 30 completely different, not related drop downs...would you create 30 lookup tables? Example of dropdowns: State,Phone Type,Status,Name Prefix,ect... Thanks, Mark ----------------------------------------> From: ----------------------------------------> jwcolby at colbyconsulting.com> ----------------------------------------> To: ----------------------------------------> accessd at databaseadvisors.com> ----------------------------------------> Date: Wed, 26 Sep 2007 ----------------------------------------> 10:12:42 -0400> Subject: Re: ----------------------------------------> [AccessD] Mucking around>>>If ----------------------------------------> you had an app with 30 drop ----------------------------------------> downs...would you create 30 ----------------------------------------> separate lookup> tables?>> If ----------------------------------------> I have an app with 10 drop ----------------------------------------> downs for state I would create ----------------------------------------> one state> lookup table and ----------------------------------------> use that for all 10 drop ----------------------------------------> downs.> If I had an app with 5 ----------------------------------------> different address type drop ----------------------------------------> downs (unlikely) I would> ----------------------------------------> create one address type lookup ----------------------------------------> table and use that for all 5 ----------------------------------------> drop downs.>> Does that answer ----------------------------------------> your question?>> One lookup ----------------------------------------> table for each "type" or ----------------------------------------> "list" (or whatever you might ----------------------------------------> call> these) table.>> John W. ----------------------------------------> Colby> Colby Consulting> ----------------------------------------> www.ColbyConsulting.com> ----------------------------------------> -----Original Message-----> ----------------------------------------> From: ----------------------------------------> accessd-bounces at databaseadviso ----------------------------------------> rs.com> ----------------------------------------> [mailto:accessd-bounces at databa ----------------------------------------> seadvisors.com] On Behalf Of ----------------------------------------> Mark A Matte> Sent: Wednesday, ----------------------------------------> September 26, 2007 10:05 AM> ----------------------------------------> To: Access Developers ----------------------------------------> discussion and problem ----------------------------------------> solving> Subject: Re: ----------------------------------------> [AccessD] Mucking around>>> I ----------------------------------------> have seen this before(and used ----------------------------------------> it)...but out of curiosity. If ----------------------------------------> you had an> app with 30 drop ----------------------------------------> downs...would you create 30 ----------------------------------------> seperate lookup tables?>> ----------------------------------------> Thanks,>> Mark A. Matte>> ----------------------------------------> ------------------------------ ----------------------------------------> ----------> From: ----------------------------------------> jwcolby at colbyconsulting.com>> ----------------------------------------> To: ----------------------------------------> accessd at databaseadvisors.com> ----------------------------------------> Date: Wed, 26 Sep 2007 ----------------------------------------> 09:54:09 -0400>> Subject: Re: ----------------------------------------> [AccessD] Mucking around>> The ----------------------------------------> general argument is that you> ----------------------------------------> have THREE columns.>> PKID> ----------------------------------------> TypeOfDataID> Data>> The ----------------------------------------> TypeOfDataID might> be:>> 1 ----------------------------------------> Cities> 2 States> 3 Name ----------------------------------------> prefixes (Mr. etc)> 4 Address ----------------------------------------> Types> Etc>> Etc>> So you ----------------------------------------> might have data that looks ----------------------------------------> like:>> 1 2 CA> 2 2 AZ> 3 3 ----------------------------------------> Mr> 4 3> Mrs> 5 4 Home> 6 4 ----------------------------------------> Work> 7 4 Shipping> 8 1 San ----------------------------------------> Diego>> Thus you have place> ----------------------------------------> all of your single column ----------------------------------------> "type of something" data into> ----------------------------------------> a single table with> another ----------------------------------------> column which allows you to ----------------------------------------> find only the cities,> or ----------------------------------------> states, or> types of addresses ----------------------------------------> or (place your list data type ----------------------------------------> here).>> It works, but it> ----------------------------------------> causes headaches, but people ----------------------------------------> do it.>> John W. Colby> Colby ----------------------------------------> Consulting>> ----------------------------------------> www.ColbyConsulting.com> ----------------------------------------> -----Original Message-----> ----------------------------------------> From:> ----------------------------------------> accessd-bounces at databaseadviso ----------------------------------------> rs.com>> ----------------------------------------> [mailto:accessd-bounces at databa ----------------------------------------> seadvisors.com] On Behalf Of ----------------------------------------> Susan Harkins>> Se!> nt: ----------------------------------------> Wednesday, September 26, 2007 ----------------------------------------> 9:42 AM> To: 'Access ----------------------------------------> Developers> discussion and ----------------------------------------> problem solving'> Subject: Re: ----------------------------------------> [AccessD] Mucking around>>> ----------------------------------------> Except that tables are ----------------------------------------> supposed to store like data, ----------------------------------------> not data that simply>> looks ----------------------------------------> similar and happens to have ----------------------------------------> the same structure. I would ----------------------------------------> think the>> data's purpose ----------------------------------------> matters more in the decision ----------------------------------------> than the data's structure.>>> ----------------------------------------> Susan H.>> LOL. Proper ----------------------------------------> normalization says that it is ----------------------------------------> not necessary. Never> the ----------------------------------------> less> there are those who ----------------------------------------> argue vociferously for this ----------------------------------------> method.>>> -->> AccessD ----------------------------------------> mailing list> ----------------------------------------> AccessD at databaseadvisors.com>> ----------------------------------------> http://databaseadvisors.com/ma ----------------------------------------> ilman/listinfo/accessd> ----------------------------------------> Website:> ----------------------------------------> http://www.databaseadvisors.co ----------------------------------------> m>> --> AccessD mailing list>> ----------------------------------------> AccessD at databaseadvisors.com>> ----------------------------------------> http://databaseadvisors.com/ma ----------------------------------------> ilman/listinfo/accessd> ----------------------------------------> Website:> ----------------------------------------> http://www.databaseadvisors.co ----------------------------------------> m>> ----------------------------------------> ______________________________ ----------------------------------------> ______________________________ ----------------------------------------> _____> News, entertainment and ----------------------------------------> everything you care about at ----------------------------------------> Live.com. Get it now!> ----------------------------------------> http://www.live.com/getstarted ----------------------------------------> .aspx> --> AccessD mailing ----------------------------------------> list> ----------------------------------------> AccessD at databaseadvisors.com> ----------------------------------------> http://databaseadvisors.com/ma ----------------------------------------> ilman/listinfo/accessd> ----------------------------------------> Website: ----------------------------------------> http://www.databaseadvisors.co ----------------------------------------> m>> --> AccessD mailing list> ----------------------------------------> AccessD at databaseadvisors.com> ----------------------------------------> http://databaseadvisors.com/ma ----------------------------------------> ilman/listinfo/accessd> ----------------------------------------> Website: ----------------------------------------> http://www.databaseadvisors.co ----------------------------------------> m _________________________________________________________________ Connect to the next generation of MSN Messenger http://imagine-msn.com/messenger/launch80/default.aspx?locale=en-us&source=w lmailtagline -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com