On 21 May 2002, at 14:34, Karen Miller wrote:
> This is an example of what I have
>
> 1) one table (staff) listing:
> Student ID number (auto number)
> last name,
> first name,
> staff level,
> start date,
> branch location.
>
> 2) one table listing classes
> auto number
>
> 3) An enrollment table
> id showing auto number,
> student id showing number
> classid showing number
> date id showing date/time
>
> This table is to help me relate the 2 previus tables, but when I go to the
> drop down box in enrollment class IDS and DateID, it shows nothing
> even though I have data listed in the 1st 2 files. The student ID does
> list students.
>
> Thanks
>
> Karen
It sounds to me like although you've given the fields in the third
table the names of fields from the first two, you haven't quite
managed to tell Access that these fields are supposed to refer to
entries in those other tables.
There's a special term for this: "foreign key". I think if you
search for help on that, it will guide you through defining the
relationship between the tables that you need.
David Gillett
The NOSPIN Group Promotions is now offering
Mandrake Linux or Red Hat Linux CD sets along
with our NOSPIN Power Linux CD... at a great price!!!
http://freepctech.com/goodies/promotions.shtml
|