Hello there. I believe I understand your issue but I need some clarification.
- Where is "Table C"? - Is it in a 3rd base? Or does it live in "Base 2"
- What subscription plan do you currently have? - Multi-source syncing is only available to Business/Enterprise customers
I have a feeling your subscription plan may be holding you back. Either way let me know and we can figure something out for you.
🤘Airtable Rocks 🤘
If you want data updates from Table A and Table B to flow into Table C continuously, I'm afraid you're going to need to use multi-source syncing, which requires a Business and above plan: https://support.airtable.com/docs/multi-source-syncing
How are Table A and Table B used? f it's purely for data entry, you could create Interfaces that work off of Table C and give those to the users of Table A and Table B instead, which would let you have a consolidated view and also keep the data hidden from the users of Table A and B