Solved Form Data to Save to Table AND APPEND another Table

[Minty]

I think this is one of those salient examples when we all say avoid spaces in table and field names, it's precisely for this type of issue.
It still catches even really experienced eyes out, because we wouldn't normally make a table with a name formatted like that.

Have a read up and get yourself a naming convention.

 

[pbaldy]

I agree 100% and will add symbols to the list. Things like "Invoice#" seem cool until you realize the grief it will cause.