Forum Discussion
Question on exporting MS Access tables to Sharepoint Online List
I have a MS Access file with 14 tables. Some of these tables I am able to export them without any issue. However I noticed that some tables have records where each have "sub records" in collapsable f...
Those are records in another table that is related to the main table. you can create something similar in SharePoint by using Lookup tables. To do this, you will need to create the reference/lookup tables/lists before you create the main list.
While SP has the ability to link together several lists, I would not recommend trying to do this with more than 3 levels deep. The user experience typically becomes complicated, unless you do some custom coding.