I know I am probably missing something very simple here but I hope someone can set me straight to stop my misery. I have one table with about 700 people (first and last name fields). I need to create other tables with additional information about each person but I don’t want to retype all the same information (first & last name) for each table and I don’t want to use the lookup wizard to select a name one at a time.
What is the best way to create other related tables and how?
Maybe another way to stating the same thing is how can I populate a new table with information form an existing table?