Re: Simple question

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

From: Brad (ballison_at_ukcdogs.com)
Date: 01/05/05 

Date: Wed, 5 Jan 2005 16:13:48 -0500

Kent,

Thanks for the information and what you told me is what I thought I would
have to do. This was a simple smaller project that turned into a bit larger
one.

We were using Access, but now have MSDE (SQL).

If I have any questions, I will ask, but I hopefully will know what I am
doing. Now it is just a matter of time.

Thanks again,

Brad

"Karl Albrecht" <NO_SPAMkarlman@pacbell.net> wrote in message
news:e9Em1U28EHA.3988@TK2MSFTNGP10.phx.gbl...
> 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
    ... I would create one table for entrant information, ... > 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: Primary Key & Data Entry Forms
    ... In dog showing there are 7 groups toy, utility, working, terrier, hound, ... The manual entry forms we receive will have one exhibitor but could have ... Title, AnimalType, FeeType, etc): ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Primary Key & Data Entry Forms
    ... I would expect that it would at least be worth having next year's show in the same database, as it would save typing many of the exhibitor's details again. ... Breed table (one record for each breed of dog), ... If you don't have an exhibitor entering in multiple shows, you can skip this and use a single table for the exhibitor info and the entry in the show. ...
    (microsoft.public.access.tablesdbdesign)