Topic profile page for Junction table.
This page has aggregated data from forum posts, threads, listings, online discussions, newsgroups, messageboards, and other online sources which contain user generated content for the term: Junction table.
Topic "Junction table" was discussed 417 times on 33 sites in last 3 months
Started 1 week, 4 days ago (2009-11-04 19:27:00)
by Kevsim
I have a table called Fix and another called Documentation. These 2 tables are connected to each other through a junction table which has the keys FixID and DocumentationID. There is a form called Fix, the form works well with all the Fix controls, add new record, edit record etc. I have added a combo box called Documentation (to update the Documentation table) along with all the Fix controls....
Started 5 days, 20 hours ago (2009-11-09 23:55:00)
by Kevsim
randy700, Thank you for all your help, success at last. I have corrected the SQL statement, I had the table mentioned twice in INSERT INTO and I had to remove the middle brackets between text and combo boxes. Find revised code - strSQL = "INSERT INTO T_Junction(FixID,DocsID)VALUES (" strSQL = strSQL & Me.[Text188] & "," & Me.[Combo350] & " );" DoCmd.RunSQL strSQL All working OK. kevsim
Started 1 week, 6 days ago (2009-11-02 14:18:00)
by Maria J
I have a straightforward question: do I have to manually create a junction table in Access 2007 for a M to M relationship if I'm going to have as PK, two FK which are Autonumbers from the linked tables? I can't see how Access will know "on it's own" how the junction table goes. I'm going to use this junction table for linking a clients table (with PK client ID Autonumber) and a services table (...
Started 5 days, 17 hours ago (2009-11-10 03:49:00)
by Atomic Shrimp
Fair enough - that also works. I don't think a composite key would hurt here though, given that it would be based on two entirely synthetic foreign keys (if it was a composite of client account number and some human-readable service code, I would be dead against it)
Started 2 months, 1 week ago (2009-09-03 02:59:23)
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. ...
Started 2 months, 2 weeks ago (2009-08-27 16:29:00)
by vbnetman via AccessMonster.com
A portion of my db deals with parts and what they fit. For example, one piece of equipment can have many parts and more than one piece of equipment can have the same part, an oil filter for example. I’ve arranged a junction table to handle this. I have 3 tables: TblUnits – unitId is PK TblParts – partNo is PK TblFits(...
Started 2 months, 2 weeks ago (2009-08-28 14:42:00)
by John W. Vinson
On Fri, 28 Aug 2009 19:21:42 GMT, "vbnetman via AccessMonster.com" wrote: >OK, I understand. Now the combo box. Have a user make a parts selection with >this and then code something like refPartsID.value = combo box.value to >populate to fits table? You don't have to write code for everything. In fact for an ...
Started 2 months, 1 week ago (2009-09-05 08:18:00)
by DTR_Projekt
Not Ranked : +0 / -0 0 score FS:Junction Produce Front Table for Lexus LS430 Selling my pretty much brand new Junction Produce Front Table for Lexus LS430. Used only for one cruise and one show. Still have original box. No cups has been used ...
Started 3 months ago (2009-08-16 05:25:00)
by OchaOcha
Thank you for the help. I figured out the problem: the tables were being referenced wrong. I had to go from one table to my junction table then from that to another. Took a while, but got it sorted out. Thank you, though. I appreciate the pointers. Marked As Answer by Chris Robinson- MSFT Owner Monday, August 17, 2009 4:30 PM