Glenn,
I will try that out. so to be clear, I am adding two more tables to my design? I am trying to visualize your scenario. How would those tables get populated?
Jim Wagner
On Friday, April 17, 2015 1:59 PM, "'Glenn Lloyd' argeedblu@gmail.com [MS_Access_Professionals]" <MS_Access_Professionals@yahoogroups.com> wrote:
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
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: Jim Wagner <luvmymelody@yahoo.com>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (3) |
.
__,_._,___
Tidak ada komentar:
Posting Komentar