jack drawbridge
jackandpat.d at gmail.com
Wed Mar 16 23:30:41 CDT 2011
Rocky, Just curious, but why 3 tables? jack On Thu, Mar 17, 2011 at 12:16 AM, Rocky Smolin <rockysmolin at bchacc.com>wrote: > Dear List: > > I'm putting together an app for a client that will have three tables that > will have address information. There will probably be no overlap. > > Normally I would put address, city, state, zip, main phone, main fax, etc., > fields into each table. > > Is there any reason to make an "address" table with an autonumber PK and an > FK to the address table in each of the other three tables? > > > > MTIA > > > Rocky Smolin > > Beach Access Software > > 858-259-4334 > > Skype: rocky.smolin > > www.e-z-mrp.com <http://www.e-z-mrp.com/> > > www.bchacc.com <http://www.bchacc.com/> > > > > > > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com >