Web Development

Ask something
Question Locked

Foreign key problem not picking up correct ID numbers

0 helpful
3 replies

by magsin6

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Dear Experts

In a table called Schedule I have a foreign key to the Volunteers table, however when I open the Schedule table it picks up id numbers as 1 and 0 instead of the id numbers that are in the Volunteers table which are 1 and 2. If I make the foreign key a lookup with first and last names from the Volunteers table it shows the correct names. When I run a query it also shows the correct names. When I run the mailmerge the Volunteer id's are shown as 0 and 1. I am using Access 2003. I would be so grateful for any help as I have been trying to resolve this for over a week.

Kind regards

Margaret

3 replies

by john.a.wills

What picks up id numbers as 1 and 0?
Foreign keys are pretty well what you put in the FK column.
I am not sure I am envisaging your problem accurately.

by tony hopkinson

Foreign Key is for master detail

e.g.

Schedules
ScheduleID
VolunteerID

Volunteers
VolunteerID
VolunteerFirstName
VolunteerLastName

So in the gui you'd link Schedules to Volunteers by VolunteerID

Choose a Schedule you get 0 - n Volunteers

Look Up is something else entirely

Thay would be to choose a volunteer, by name and then set the volunteerID in schedules.

This discussion is closed to new replies.