I have 2 databases (roles & read only roles). The read only roles contains all the tables from roles (by linking) by in read only view.
The problem we are having is one of the linked tables that has a subdatasheet (another table) in it won't appear in the read only roles with the subdatasheet. You can't edit the table because it's a linked table. Any idea what could be going wrong? I have tried relinking, that has not working. We do have another table with a subdatasheet working fine.
Any ideas would be great. Thanks!
The problem we are having is one of the linked tables that has a subdatasheet (another table) in it won't appear in the read only roles with the subdatasheet. You can't edit the table because it's a linked table. Any idea what could be going wrong? I have tried relinking, that has not working. We do have another table with a subdatasheet working fine.
Any ideas would be great. Thanks!