Creating new tables

[OrlyE]

Hello, all;


Fairly new to Access, but have a working knowledge of Excel. I am working on a dataBase and I need to have it check if a set of tables exist based on the data of another table and if any do not exist create the table(s) based on a template. the caviat is that the data in one table are both names of tables and field in another.

Table1 has fields named 'first name' and 'last name'; the data in that field is for example Peter Adams, John Smith. I need to check on start that the tables named PAdams, JSmith.and so on exist, if not create them from a table template with fields 'vacation', 'personal', 'sick, etc. also i need to check on startup that a table named Department exist; if not, create it with fields named PAdams, JSmith and so on.... is that possible? and can you guide me in the right direction?

Thank You.

[June7]

This is not a good design for relational database. Should not have separate tables for each individual. Should be one table. Constantly modifying data structure will drive you nuts. Every time you add a table, will have to redesign or create new queries, forms, reports, code.

Forget everything you know about Excel. Relational database is completely different animal. Maybe this will help http://www.rogersaccesslibrary.com/