You might like to check this thread from a short while ago:
It doesn’t give a solution, but you could check your set-up against the questions raised there.
I think, in your position, I would use Numbers/Excel and import the sheet into Research and open it in whichever from there when I wanted to view it/add data, or alternatively add a link to the file in Project notes which would open appropriately on clicking.
I have never used native tables in Scrivener, but on a quick trial of a 4 row 3 column table, I found problems/issues that mean Apple’s TextKit tables code is really borked (on my machine: M2Pro Mac Mini, MacOS 15.7.3, Scrivener 3.5.1). I’ll post that separately.
![]()
Mark