Re: Simple question
From: Brad (ballison_at_ukcdogs.com)
Date: 01/06/05
- Next message: Mitchell Vincent: "Re: VistaDB.net ?"
- Previous message: Veign: "Re: Saving Outlook Emails"
- In reply to: Karl Albrecht: "Re: Simple question"
- Next in thread: Karl Albrecht: "Re: Simple question"
- Reply: Karl Albrecht: "Re: Simple question"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 6 Jan 2005 13:55:04 -0500
Karl,
Okay now my frustration is lying with Crystal Reports. I hav created a
dataset that has two tables with the relation between the two and now I get
a messagebox from Crystal Reports stating that I have to log onto the
server.
Frustrating!
"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
>>
>>
>
>
- Next message: Mitchell Vincent: "Re: VistaDB.net ?"
- Previous message: Veign: "Re: Saving Outlook Emails"
- In reply to: Karl Albrecht: "Re: Simple question"
- Next in thread: Karl Albrecht: "Re: Simple question"
- Reply: Karl Albrecht: "Re: Simple question"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
