InfoPath Dev

Yes, indeed.  Appears to been a capitalization issue.  Amazing how one single letter can throw the entire formula off....  I missed a cap and when I put it in it worked fine.  Thanks!

I'm literally pulling my hair out over this one.   I have a drop down list box (@Type) that is based on a field in a secondary data source that is from an Access table.  tblSAAuditItems.  The field saves to the main data source which is at ...

I worked around it by basing the Category drop down on a query instead of the table.  In the query I included a field called CategoryName & a field called Category and filtered it.  I based the drop down on the query connection and the entries on the query.  I based the value & display name on Category instead of ...

My issue falls along this line...  I had 2 fields called Category (in 2 different tables).  I changed the one in my secondary data source to CategoryName. It populates the drop down box for the Category field in the Main connection but when I try to submit data to the main table using the Main connection it says: InfoPath cannot ...

HALLELUAH!  Finally working.  Changed one of my Category fields to CategoryName.  Apparently these formulas don't like items named the same thing in 2 different tables.  CategoryName=Current()/@Category worked.  

You guys must have given up on me!!  But Im going to try a little more clarification: I have a Main data source that looks like this: myfields -datafields --d:tblMainAuditInfo ---field1 (insignificant) ---field2 (insignificant) ---etc (insignigicant) -----tblSAAudit (repeating) linked to tblMainAuditInfo by insignificant key ...

I spoke too soon.  The record is no longer completely repeating itself and my drop downs are working using current()/../d:tblSAAudit/@category BUT, when I move to the second record, the selections from the first record are included in the list.  I've again, seen postings to resolve this but they aren't working.  I tried ...

When all else fails start over.  It's working now.  Thanks!

I just realized that it's not just the cascading drop downs.  The whole record repeats itself.  It will add a new record to the table but if I change the selections in each new record, it changes all of the records to the same thing...  do I have to do the current() on ALL the fields in the Repeating table?  Thanks!

 First of all...  Thanks for the quick reply!!  current()/../d:tblSAAudit/@Category gets the cascading drop downs working again but when I hit "insert item" on the repeating table, my selections from the first row still carry through to the next and if I change them in one row they change in all rows.  ??