Jim
When I said there are (at least) two ways to populate the junction tables, one of the ways I had in mind was a form bound to the table on one side of the junction with a sub from bound to the junction table. You can use a combo to select the id's on the subform. The combo would be bound to the other side of the junction table and list the choices.
The other possibility is to use via and DAO to automate the process.
Glenn
-------- Original message --------
From: "Jim Wagner luvmymelody@yahoo.com [MS_Access_Professionals]"
Date:2015-04-17 6:32 PM (GMT-05:00)
To: MS_Access_Professionals@yahoogroups.com
Subject: Re: [MS_AccessPros] Table Design question
Glenn,
I have not thought that far ahead because I wanted to make sure I had the design correct. Maybe a form.
Jim Wagner
On Friday, April 17, 2015 2:45 PM, "Glenn Lloyd argeedblu@gmail.com [MS_Access_Professionals]" <MS_Access_Professionals@yahoogroups.com> wrote:
Jim
Yes that is correct, you would be adding two additional tables. There are a couple of ways to populate them. How do you intend to populate the main tables?
Glenn
-------- Original message --------
From: "Jim Wagner luvmymelody@yahoo.com [MS_Access_Professionals]"
Date:2015-04-17 5:06 PM (GMT-05:00)
To: MS_Access_Professionals@yahoogroups.com
Subject: Re: [MS_AccessPros] Table Design question
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: Glenn Lloyd <argeedblu@gmail.com>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (6) |
.
__,_._,___
Tidak ada komentar:
Posting Komentar