Posts Topics Forums Images
Search videos from message boards Videos Search messages from microblogs Microblogs Search messages from imdb.com Imdb Search messages from yuku.com Yuku Search messages from lefora.com (free forums) Lefora
My account: Login | Sign Up
Loading... 

Thread: Junction Table usage- query table?
Started 3 months, 3 weeks ago by ivanj
Hi, There is a many to many relationship between my contacts and project for which I used a junction table (ProjectID and ContactID are the fields). Now I need to set up a form for the projects where it can associate various contacts. FYI, among the contacts there will be clients and contractors. The contractors can work on many projects and one project may have many contractors. ...
Site: Access World Forums  Access World Forums - site profile
Forum: General  General - forum profile
Total authors: 2 authors
Total thread posts: 4 posts
Thread activity: no new posts during last week
Domain info for: access-programmers.co.uk

Other posts in this thread:

Banana replied 3 months, 3 weeks ago
Few possible approaches, you need to choose what would suit your specific process best. 1) Use a subform where the parent form is bound to one of one-side table (e.g. Project for instance), while the subform would be bound to the junction table. Usually, we would use continuous subform or datasheet but it need not be that way, and represent selections for the other one-side table with a ...
Size: 1,168 bytes
Customize:  Customize "<b>Reply 1</b>: Junction Table usage- query table? :: General :: Access World Forums"

ivanj replied 3 months, 3 weeks ago
Hi Banana, Thanks for the tip. I used #1. Works! 1) I added a main form that was linked to Contacts (customers) 2) I added a subform with the wizard, and when it asked me to make the connection, I connected it to the Contact Id between the Contacts table and Junction table. 3) I added all the fields from the junction. Since the fields from the junction table are lookups from the ...
Size: 537 bytes
Customize:  Customize "<b>Reply 2</b>: Junction Table usage- query table? :: General :: Access World Forums"

Banana replied 3 months, 3 weeks ago
Glad you were able to work out a solution.
Size: 132 bytes
Customize:  Customize "<b>Reply 3</b>: Junction Table usage- query table? :: General :: Access World Forums"

 

Top contributing authors

Name
Posts
Banana
2
user's latest post:
Junction Table usage- query table?
Published (2009-09-03 05:42:00)
Glad you were able to work out a solution.
ivanj
2
user's latest post:
Junction Table usage- query table?
Published (2009-09-03 05:38:00)
Hi Banana, Thanks for the tip. I used #1. Works! 1) I added a main form that was linked to Contacts (customers) 2) I added a subform with the wizard, and when it asked me to make the connection, I connected it to the Contact Id between the Contacts table and Junction table. 3) I added all the fields from the junction. Since the fields from the junction table are lookups from the Contacts and Projects table, it worked just fine. Thanks for the...

Related threads on "Access World Forums":

Many-to-Many Relationship (Junction table) Problem  Access World Forums - site profile General - forum profile Many-to-Many Relationship (Junction table) Problem
Many-to-Many Relationship (Junction table) Problem
Junction table ans subforms  Access World Forums - site profile Forms - forum profile Junction table ans subforms
Junction table ans subforms
Junction Table Needed??  Access World Forums - site profile DeVoteD - forum profile Junction Table Needed??
Junction Table Needed??
Need help with junction table(s) construct  Access World Forums - site profile General - forum profile Need help with junction table(s) construct
Need help with junction table(s) construct
Using a junction table in a form?  Access World Forums - site profile Forms - forum profile Using a junction table in a form?
Using a junction table in a form?
Junction table record additions  Access World Forums - site profile Tables - forum profile Junction table record additions
Junction table record additions
Junction table -number or autonumber?  Access World Forums - site profile Tables - forum profile Junction table -number or autonumber?
Junction table -number or autonumber?
Junction Table  Access World Forums - site profile Tables - forum profile Junction Table
Junction Table
?junction table? Sales_Items, Item_Types, and Menus: How...  Access World Forums - site profile Theory and practice of database design - forum profile ?junction table? Sales_Items, Item_Types, and Menus: How to put this together?
?junction table? Sales_Items, Item_Types, and Menus: How to put this together?
Junction Table is Not Populating  Access World Forums - site profile Tables - forum profile Junction Table is Not Populating
Junction Table is Not Populating

Related threads on other sites:

SQL Query question : how to add data to two tables...  Microsoft TechNet Forums - site profile Getting started with SQL Server - forum profile SQL Query question : how to add data to two tables connected by third Junction-table.
SQL Query question : how to add data to two tables connected by third Junction-table.
Tricky query problem updating junction table  Tek-Tips Forums - site profile Microsoft: Access Queries and JET SQL - forum profile Tricky query problem updating junction table
Tricky query problem updating junction table
SQL Query question : how to add data to two tables...  TechNet Forums - site profile Getting started with SQL Server - forum profile SQL Query question : how to add data to two tables connected by third Junction-table. - TechNet Forums
SQL Query question : how to add data to two tables connected by third Junction-table. - TechNet Forums
Table validation on junction table or form-level? in...  Discussions in microsoft.public.access - site profile microsoft.public.access - forum profile Table validation on junction table or form-level? in microsoft.public.access
Table validation on junction table or form-level? in microsoft.public.access
Linking a table with a lookup field to a junction table  Tek-Tips Forums - site profile Microsoft: Access Tables and Relationships - forum profile Linking a table with a lookup field to a junction table
Linking a table with a lookup field to a junction table
Multiple master table usage and lookup table usage in...  www.oracle.com - site profile Designer - forum profile Multiple master table usage and lookup table usage in same module component
Multiple master table usage and lookup table usage in same module component
Join a table, queryfails with "Query input must...  Microsoft Office (Excel, Word) forum - OfficeFrustration - site profile Running & Setting Up Queries - forum profile Join a table, queryfails with "Query input must contain at leastone table or query
Join a table, queryfails with "Query input must contain at leastone table or query
TRAVEL.com ® - Very simple Watford Junction Saver BoJ...  TRAVEL.com ® Travel Forums - site profile UK Railway Forum - forum profile TRAVEL.com ® - Very simple Watford Junction Saver BoJ query - Unbiased User Comments, Feedback, Reviews
TRAVEL.com ® - Very simple Watford Junction Saver BoJ query - Unbiased User Comments, Feedback, Reviews
MS Access metadata repository generation query, matrix...  www.microsoft.com/communities/newsgroups/list/en-us/default.aspx?dg=microsoft.public.access.tablesdbdesign - site profile microsoft.public.access.tablesdbdesign - forum profile MS Access metadata repository generation query, matrix generation query, table-generation query, array-generation query. in microsoft.public.access.tablesdbdesign
MS Access metadata repository generation query, matrix generation query, table-generation query, array-generation query. in microsoft.public.access.tablesdbdesign
Junction box usage  DoItYourself.com Community Forums - Home Improvement & Home Repair Questions & Answers - site profile Electrical - A/C & D/C - forum profile Junction box usage
Junction box usage
Thread profile page for "Junction Table usage- query table?" on http://www.access-programmers.co.uk. This report page is a snippet summary view from a single thread "Junction Table usage- query table?", located on the Message Board at http://www.access-programmers.co.uk. This thread profile page shows the thread statistics for: Total Authors, Total Thread Posts, and Thread Activity