If that isn't sufficient to get your solution up and working, feel free to post again with a more detailed description of your tables, relationships and the precise task you are trying to accomplish
Whether you add a new record that copies data from a related record or that simply links to it is often a key design decision to make when creating a database. Either option can be the right or wrong way to go depending on the requirements of your database.
Thanks for the quick answers. I think I must have suffered a stroke and gotten partial amnesia as what I want to do I know is very simple and I have two other databases I wrote that use it but the $%#$ I cannot see what I am doing wrong.
I do have a question and that is in Guy Stevens video why wasn't he using a pop up instead of a drop down? The pop up will display the 2nd field?
I am still working on the previous question.
Pop up menus and drop down lists are very similar. One can often be used in place of the other, but a pop up menu has a nice feature in that it can show the second field value of a value list after a value has been selected and the cursor is now in another field. A drop down list, on the other hand will show the ID number instead of the name. This assumes that Guy's video shows using a value list that has a customer ID as field 1 and a name field as field 2.