Question

Locked

Foreign key problem not picking up correct ID numbers

By magsin6 ·
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

This conversation is currently closed to new comments.

3 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Answers

Collapse -

"it"

by john.a.wills In reply to Foreign key problem not p ...

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.

Collapse -

Huh

by Tony Hopkinson In reply to Foreign key problem not p ...

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.

Back to Web Development Forum
3 total posts (Page 1 of 1)  

Related Discussions

Related Forums