|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
Be the architects of evolution and help create the mobile internet future. It’s your move---enter to win here! |
|
#1
April 25th, 2004, 11:27 AM
|
|||
|
|||
|
MS query help
This is a college project for my parents farm: I am trying to make a query where after the user enters in some dates for a between command I would also like it to ask if the user would like to create a new LID (litter ID) in another table. How do I go about this? I also need this to work so that when I make a report it will automatically put the new LID into the report. IF you need more info let me know.
Tables Boar Litter PreweaningDeaths Services Sow/Gilt Thanks Chris
|
|
#2
April 25th, 2004, 02:20 PM
|
|||
|
|||
|
Here is the structure of my DB:
Boar BID(PK) DateEnteredHerd CulledDate CulledReason UID(FK) Sow/Gilt ID(PK) DateEnteredHerd Genetics CulledDate CulledReason DiedDate DiedReason UID(FK) Services SID(PK) ID(FK) BID(FK) DateBred DateToFarrow FailedToFarrow BreedingComments UID(FK) Litter LID(PK) DateFarrowed NumberBornLive DateWeaned NumberWeaned Mastitis Stillborn Mummies SID(FK) UID(FK) PreWeaningDeaths PID(PK) LID(FK) DateDied Cause UID(FK) UserID UID(PK) FirstName LastName
|
|
| Viewing: Dev Shed Forums > Databases > MS SQL Development > MS query help |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
