SQL Server's OpenJson function will let you dismantle JSON structures into relational tables, including tables with foreign/primary key relationships. As I noted in an earlier column, JSON is great ...

Here are the details to two versions of Product Tables, one for Access 2000/97 and one for SQL Server 7. Not all of these fields are necessary in one database. For example, with Size and color you can ...