[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: Jim Wagner <luvmymelody@yahoo.com>

---

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (1)

Visit Your Group

• New Members 2

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___