I am developing a database for our local public school. I have two tables: one containing students and one containing parents. The parent table as look-up fields for the children that references the fields for first and last name in the students table. My problems:
1. While the full names of all students appear in the look-up field, they appear in order of entry. Is there a way to make them appear alphabetically?
2. Although the full names appear in the drop down list, only the first names actually appear in the parents table. How can I get both first and last name to appear?
3. When I use mail merge in Word with my school database as the data source, the look-up fields come in as numbers, no names at all. How do I get names into my Word merge document?
Thanks for any help that anyone can provide. I am not a frequent user of Access, and have never done any programming within Access.