Let’s begin by creating the Employer table first, along with the EmployerActivity. It’s good practice to abstract your SQLite database creation logic into a class. This helps with maintainability.

It's possible that, once saved to disk, these tables could be used "as is" in my data warehouse or transactional system. Alternatively, I could also use the Table variables I've created here in a SQL ...

Restriction for create table statements Do not use ALTER operations Don’t use cascading deletion from tables (is forbitten). Please use only simple primary and foreign keys (single column/attribute).

Create a query from within Access that attaches to my SQL Server and retrieves the recordset. I'd likely use the same technique I applied in this thread. <BR>2.