First a little background, I am a new database user, I own a jewelry making business.
I have 2 tables, one is for the parts that I use to make my jewelry and the other is for the jewelry itself.
I need a way to have multiple jewery parts lised on the jewelry layout, with their descriptions and photos.
I have joined the part number field on both tables
I have tried adding a field for the part number and have FM look up the description and the photo, it worked.
When I copied those fields so that I could add another part number things went wrong. After I tried to enter a second part number it changed them both to the second one I added.