re: Any Microsoft Access Experts?

quote:

---

How do I make it xfer then? And is there an easier way to do what I'm trying to do? It's really not a complicated table, but this is the main piece I'm missing.

---

The point of relational databases is so you don't have to transfer or duplicate information. The foreign key is there for the purpose of linking a record in one table to a record(s) in another, and you gather the information you need via queries rather than thinking of it like you need to read a spreadsheet and see all the info on one "sheet".