Prev: Filtered Form
Next: What tables and fields should I use?
From: Justin Cox on 5 Dec 2009 19:44
is there a way to show which hours, temp, etc?
Any templates that you know of?
--
Thanks
Justin


"Steve" wrote:

> How about the following tables:
> TblLocation
> LocationID
> Location
>
> TblAnimalType
> AnimalTypeID
> AnimalType
>
> TblMoonPhase
> MoonPhaseID
> MoonPhase
>
> TblWeather
> WeatherID
> Weather
>
> ** You ought to consider breaking this table down to several weather
> conditions such as TblPrecipitation which includes None, Raining and
> Snowing.
>
> TblObservation
> ObservationID
> ObservationDate
> ObservationTime
> LocationID
> AnimalTypeID
> Temperature
> WeatherID
> Note
>
> Steve
> santus(a)penn.com
>
>
> "Justin Cox" <Justin Cox(a)discussions.microsoft.com> wrote in message
> news:9F8EEED8-9544-4808-A633-DF5ECDCE099B(a)microsoft.com...
> > would like to track:
> > location
> > date
> > time
> > type of animal
> > temperature
> > moon phase
> > weather
> >
> > i would like to be able to look at a chart to see best times/ temps/
> > etc...
>
>
> .
>
From: Steve on 6 Dec 2009 10:36
If you only want to allow selecting certain hours, create a table of the
hours and use that table as the row source of a combobox. Same for
temperature.

You aren't going to find any templates for what you want to do!

Steve


"Justin Cox" <jcox(a)voluntarybenefitservices.com> wrote in message
news:6D50B3AA-2898-421E-AB0A-2BB53A8C798A(a)microsoft.com...
> is there a way to show which hours, temp, etc?
> Any templates that you know of?
> --
> Thanks
> Justin
>
>
> "Steve" wrote:
>
>> How about the following tables:
>> TblLocation
>> LocationID
>> Location
>>
>> TblAnimalType
>> AnimalTypeID
>> AnimalType
>>
>> TblMoonPhase
>> MoonPhaseID
>> MoonPhase
>>
>> TblWeather
>> WeatherID
>> Weather
>>
>> ** You ought to consider breaking this table down to several weather
>> conditions such as TblPrecipitation which includes None, Raining and
>> Snowing.
>>
>> TblObservation
>> ObservationID
>> ObservationDate
>> ObservationTime
>> LocationID
>> AnimalTypeID
>> Temperature
>> WeatherID
>> Note
>>
>> Steve
>> santus(a)penn.com
>>
>>
>> "Justin Cox" <Justin Cox(a)discussions.microsoft.com> wrote in message
>> news:9F8EEED8-9544-4808-A633-DF5ECDCE099B(a)microsoft.com...
>> > would like to track:
>> > location
>> > date
>> > time
>> > type of animal
>> > temperature
>> > moon phase
>> > weather
>> >
>> > i would like to be able to look at a chart to see best times/ temps/
>> > etc...
>>
>>
>> .
>>


 | 
Pages: 1
Prev: Filtered Form
Next: What tables and fields should I use?