Hi Folks, Well, I figured it out, but I still don't understand why it works the way it does.
I created a new "regular" form and a new join form and I was able to include the "Group List" field from the User form. So that told me that there was something weird with my other forms that was preventing it from working correctly. So I saved a copy of my problematic join form, added the "Group List" field and then started to methodically delete other fields from the join until it saved. Turns out that it was the "Password" field (102) from the User form that was causing the collision. If the password field was not present, the join would save. If I added it back in so that the "Password" and the "Group List" fields were both present, I would get the 9070 error again. If I changed the FID of the "Password" field on the join form before saving, choosing a FID in the 5368709xx range, then it would save. So I have a workaround, but I still don't understand why it works this way. Any insights? Thanks. Larry On Jan 13, 2011, at 4:51 PM, L G Robinson wrote: > Hi Folks, > > Does anyone know what error number 9070 means? It is not listed in my error > messages manual. > > I receive this error when I attempt to add the "Group List" field (FID:104) > to a join form that I am developing. My support folks tell me that there > isn't anything special about FID 104 that should prevent me from adding it to > the join. If I remove that field, the form will save just fine. > > Message not in catalog -- message number = 9070 : 104, 9070, NCSUUsers > > "NCSUUsers" is the name of the join form. > > It appears to be something specific about "104". If I change the field id > before saving the form, it will save but of course, then the field does not > display correctly. It displays the group id number(s) instead of the group > name(s), which is inherent in the functionality of field 104. > > There is no other field on the join form with an id of 104. > > ARS: 7.6.03 > Solaris: 10 > Oracle: 11.2.0.1.0 - 64bit Production > > Thanks. > Larry > > > Larry Robinson n...@ncsu.edu > Office of Information Technology > NC State University 919-515-5432 Voice > Raleigh, NC 27695-7109 919-513-0877 FAX > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"