Table lookup for a date field

[Marlene McCall]

Hi all

I am creating a data base that tracks information pertaining to musical
performances by a group of musicians.

I have five tables:
Songs: SongName, RecordedBy, YearRecorded, Comments
Sessions: SessionDate, HostedBy, SessionType
Musicians: FirstName, LastName, Phone, many other fields...
Instruments: Instrument

In the he fifth table, called Performances, each record represents the
playing of a particular song by a particular musician on a particular date.
Therefore, the four fields in this table are:

SongName (lookup from Songs)
SessionDate (lookup from Sessions)
FirstName (lookup from Musicians)
Instrument (lookup from Instrument)

Everything is working great except one thing which is driving me nuts. I
cannot get the SessionDate lookup to work. The only thing different about
this field compared to the other three is that it is a date field rather than
a text field. I have searched for information that lookups cannot be used
with date field, in vain.

Here is what I have done:

In the design of the Performances table, I select the SessionDate field.
When I do this, however, clicking on the 'Lookout" tab below gives me a blank
screen. In other words, it's greyed out -- I don't have the option to create
a lookup.

Am I just out of luck? Are my only options for the SessionDate field to
enter it manually for each record, or else change the default value every few
records? (This what I'm doing now.)

Any help would be appreciated.

Thanks

Marlene

 

[Jeanette Cunningham]

Hi Marlene,

All who answer questions on this newsgroup strongly suggest that you avoid
using Lookups in tables.
To find out more, do a search on Lookups.

Jeanette Cunningham

 

[John W. Vinson]

On Sat, 15 Dec 2007 15:47:01 -0800, Marlene McCall <Marlene

In the he fifth table, called Performances, each record represents the
playing of a particular song by a particular musician on a particular date.
Therefore, the four fields in this table are:

SongName (lookup from Songs)
SessionDate (lookup from Sessions)
FirstName (lookup from Musicians)
Instrument (lookup from Instrument)

Two suggestions:

- Don't use Lookups. Period. See

http://www.mvps.org/access/lookupfields.htm

for a critique.

- Use Forms to display, edit and enter data rather than using table
datasheets. you can put Combo Boxes ("lookups") on your Form, with or without
lookup fields in the table and with or without help from the much (and justly)
maligned Lookup Wizard. Such a combo box can select Date/Time data, just as it
can select any other datatype (except for Memo or OLE Object).

John W. Vinson [MVP]