[AccessD] Invitations DB Design Ideas

Rocky Smolin - Beach Access Software bchacc at san.rr.com
Thu Jun 2 08:09:53 CDT 2005


Joe:

Actually, although it's absolutely no fun, it would seem that since it could 
be done with one flat file that a spreadsheet would be more quicker and 
easier if all you want to do is manage the data.

Rocky

----- Original Message ----- 
From: "Joe Hecht" <jmhecht at earthlink.net>
To: "'Access Developers discussion and problem solving'" 
<accessd at databaseadvisors.com>
Sent: Wednesday, June 01, 2005 11:24 PM
Subject: RE: [AccessD] Invitations DB Design Ideas


> Rocky,
>
> I can not see three names on an invitation.
>
> Worst case would be Mr. Rocky Smolin and Ms. Mrs. Smolin.
>
> Maybe and kids?
>
> Joe Hecht
> Los Angeles CA
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin -
> Beach Access Software
> Sent: Wednesday, June 01, 2005 10:08 PM
> To: Access Developers discussion and problem solving
> Subject: Re: [AccessD] Invitations DB Design Ideas
>
> Will there only be two persons' names at most?  If not, then you can put 
> the
>
> names in a name table with a foreign key to the Invitation table's primary
> key.
>
> Source could also be a table with a FK in the Invitation pointing to the
> source table's PK.
>
> Seems like maybe more trouble than it's worth for this app, though.
>
> Rocky
>
> ----- Original Message ----- 
> From: "Joe Hecht" <jmhecht at earthlink.net>
> To: "'Access Developers discussion and problem solving'"
> <accessd at databaseadvisors.com>
> Sent: Wednesday, June 01, 2005 9:37 PM
> Subject: [AccessD] Invitations DB Design Ideas
>
>
>> So my niece got engaged and I figure I better get my DB going soon.
>>
>> Right now the database is one table,
>>
>> These are typed in to readable and not names with spaces etc:
>>
>> I rec num
>> 1st Person first Name
>> 1st person last name
>> 2cd person first name
>> 2cd person last name
>> Address fields
>> Adults Invitation Represents
>> Children Invitation represents
>> Contact phone
>> Memo
>> Source (Bride/Groom/Family/friend?)
>> Invited Y/N
>> Coming y/n
>> Gift received Y/N
>> Note Sent Y/N
>>
>>
>>
>> Looking for ideas to normalize this
>>
>> OK wise guys, I know no wedding is normal but...
>>
>>
>>
>> Joe Hecht
>> Los Angeles CA
>>
>> -- 
>> 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
>
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> 




More information about the AccessD mailing list