RE: [MS_AccessPros] Table Design question

 

Jim,

 

You could add two junction tables tblDatabasesTables and tblTablesFields. This would allow you to distinguish table names that appear in more than one database and field names that appear in more than one database or table. Minimal junction tables would have one field to identify the database and one to identify the tables (tblDatabasesTables) , one field to identify the Tables and one to identify the Field names (tblTablesFields).

 

Glenn

 

From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Friday, April 17, 2015 4:53 PM
To: Access Professionals Yahoo Group
Subject: [MS_AccessPros] Table Design question

 

 

Hello all,

 

How would I design a database that can show the names of a database, the table names and the fields in the tables.  what I have so far is below. Am I on the right track. I only want to enter a few databases in. My problem is that if there are common tables between the databases, how would that change my design?

 

Thank You

 

tblDatabase

DatabaseId

DatabaseName

TableId

 

tblTables

TableId

TableName

FieldId

 

tblFields

FieldId

FieldName

FieldExample

 

Jim Wagner

---

__._,_.___

---

Posted by: "Glenn Lloyd" <argeedblu@gmail.com>

---

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (2)

Visit Your Group

• New Members 2

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___