AnsweredAssumed Answered

relationships

Question asked by JenniferWiles on Dec 21, 2010
Latest reply on Dec 22, 2010 by philmodjunk

Title

relationships

Post

hi,

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.

 

Any advice?

 

Jennifer

Outcomes