I have made two fm5 databases. The first is "Art Inventory" the second is "Art Competitions". I list all my art works in "Inventory", and all the competitions I enter are listed in "Competitions". When I submit slides of an art work to a competition it is listed in a repeating field called SLIDES SENT (field values defined by ART TITLE from "Art Inventory"
. Multiple unique entries are made per venue (I send duplicate slides to several venues). What I can not figure out is how to have each unique venue to which I send slides automatically appear in the repeating field SUBMISSION HISTORY in the "Art Inventory" database. I can not get multiple venues to appear in the repeating field. ANY SUGGESTIONS WOULD BE APPRECIATED!!!
. Multiple unique entries are made per venue (I send duplicate slides to several venues). What I can not figure out is how to have each unique venue to which I send slides automatically appear in the repeating field SUBMISSION HISTORY in the "Art Inventory" database. I can not get multiple venues to appear in the repeating field. ANY SUGGESTIONS WOULD BE APPRECIATED!!!