Re: Simple question

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Karl Albrecht (NO_SPAMkarlman_at_pacbell.net)
Date: 01/05/05 

Date: Wed, 5 Jan 2005 12:29:07 -0800

Sounds like you will want to create several tables and relate them together.
What are you using for the database backend?

I would create one table for entrant information, one table for event
information, and then a third table to cross reference the two. That way you
can have more than one entrant join an event and any single entrant could be
in more than one event.

Let me know if you need help setting that up...

Karl

"Brad" <ballison@ukcdogs.com> wrote in message
news:OyIBhy18EHA.1692@TK2MSFTNGP10.phx.gbl...
> Because I am not and do not proclaim to be a DBA, I need a bit of help.
> Here is the scenario:
>
> I am working on a VB program that stores entries into a dog show. Each
> entrant is assigned an armband number and each entry is one dog, however
> each entry can enter any number of 5 events over the weekend.
>
> What I am having a problem with is this; in trying to create a dataset
that
> will list the Dog's number, the owners name, the Dog's name and then under
> that list all the entries I guess I am lost.
>
> I currently have a table set up with the following fields:
>
> EntryID int 4 0
> Armband int 4 0
> ClassicID nvarchar 2 0
> EventCode nvarchar 15 0
> EventType char 1 0
> UKCNumber nvarchar 12 0
> DogName nvarchar 50 1
> Owner1 nvarchar 50 1
> Owner2 nvarchar 50 1
> EventDate datetime 8 0
> ShowTrial char 1 1
> BreedCode char 2 0
> Variety char 1 1
> EntryClass char 1 1
> EntryDiv char 2 1
> JrNumber char 12 1
> JrHandler char 50 1
> JrEntry char 2 1
> ObedVeteran bit 1 1
> MCPoodle bit 1 1
> AGentry1 char 10 1
> AGEntry2 char 10 1
> AGEntry3 char 10 1
> OBEntry1 char 10 1
> OBEntry2 char 10 1
> OBEntry3 char 10 1
> TotalDog bit 1 1
> OBJumpHgt float 8 1
>
> There is some information that I would only need stored once, but each dog
> can have several entries. So, on the armband number I need the "header"
> which would be DogNumber, DogName, OwnerName, but under that there can be
> several entries.
>
> Should I split these tables? I have tried doing a group, however then if
> the first dog was entered into three different shows then three armbands
> would print and I only need one showing this one dog, but the three shows.
>
> I apologize for being long in this post and for not being an expert right
> now at DB admin.
>
> Thanks for the help.
>
> Brad
>
>

Relevant Pages

  • Re: Simple question
    ... > can have more than one entrant join an event and any single entrant could ... >> I am working on a VB program that stores entries into a dog show. ... >> each entry can enter any number of 5 events over the weekend. ...
    (microsoft.public.vb.database)
  • [CONTEST] Childrens Book Publication
    ... "The winner will be the entrant whose story, in the opinion of the judges, demonstrates the greatest entertainment value, quality and originality. ... The prize is the offer of a worldwide publishing contract with Chicken House, which shall be subject to negotiation and completion between Chicken House and the winner." ... The entrant must personally submit the entry; any submissions from, or found to be from agents, will be void and rejected. ... Entries must be written in English, typed, double-spaced, ring-bound and clearly labelled with the entrant's full name and contact details. ...
    (misc.writing)
  • Primary Key & Data Entry Forms
    ... I am trying to create a database for entries for a dog show the following is ... same dog, if selected always 50p per additional entry), Not_For_Competition ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Simple question
    ... Okay now my frustration is lying with Crystal Reports. ... > can have more than one entrant join an event and any single entrant could ... >> I am working on a VB program that stores entries into a dog show. ...
    (microsoft.public.vb.database)
  • Re: Extract Unique List
    ... > From a list of multiple entries, how do I extract to another list of unique ... > entries, prefereably without a macro. ... You can use the advanced filter to copy the unique entries to another ...
    (microsoft.public.excel)