Its doesn't have to be the table directly - it can be a form with a subform in datasheet view, with the recordsource set in a way that's not accessing the table directly.
I thought the above was what the OP was referring to , as they mentioned a form.