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
