If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Relationships One to Many
I have read articles upon articles on relationships. Just when I think I got
it I cant create more then 1 record. I know this doesn't make a lot of sence. In an effort to sound a little more coherent I will rephrase my question: I have a table with many fields(TableA) I need to add comments to (tableA) but I do not know how many times I will need to go back to (tableA). Example (TableA) has three records and record 2 needs to have 12 comments added to it. I create another table (Comments). How do I link these? How do I get the multiple comments for TableA to stay together? Thank you, Vadimbar |
#2
|
|||
|
|||
TableA should have a primary key, let's assume an autonumber field named
"ID". You would add a Long Integer field ("AID") to the Comments table. Then you can create a form ("frmA") based on TableA. Add a subform to frmA that has a record source of the Comments table. Set the subform's properties: Link Child: [AID] Link Master: [ID] This will make sure that new records added to the comments subform will "inherit" the ID value from the main form. -- Duane Hookom MS Access MVP -- "Vadimbar" wrote in message ... I have read articles upon articles on relationships. Just when I think I got it I cant create more then 1 record. I know this doesn't make a lot of sence. In an effort to sound a little more coherent I will rephrase my question: I have a table with many fields(TableA) I need to add comments to (tableA) but I do not know how many times I will need to go back to (tableA). Example (TableA) has three records and record 2 needs to have 12 comments added to it. I create another table (Comments). How do I link these? How do I get the multiple comments for TableA to stay together? Thank you, Vadimbar |
#3
|
|||
|
|||
Thank you I will give it a try.
Vadimbar... "Duane Hookom" wrote: TableA should have a primary key, let's assume an autonumber field named "ID". You would add a Long Integer field ("AID") to the Comments table. Then you can create a form ("frmA") based on TableA. Add a subform to frmA that has a record source of the Comments table. Set the subform's properties: Link Child: [AID] Link Master: [ID] This will make sure that new records added to the comments subform will "inherit" the ID value from the main form. -- Duane Hookom MS Access MVP -- "Vadimbar" wrote in message ... I have read articles upon articles on relationships. Just when I think I got it I cant create more then 1 record. I know this doesn't make a lot of sence. In an effort to sound a little more coherent I will rephrase my question: I have a table with many fields(TableA) I need to add comments to (tableA) but I do not know how many times I will need to go back to (tableA). Example (TableA) has three records and record 2 needs to have 12 comments added to it. I create another table (Comments). How do I link these? How do I get the multiple comments for TableA to stay together? Thank you, Vadimbar |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Mixed up with Relationships..help! | KrazyRed | New Users | 3 | January 26th, 2005 05:03 AM |
Deleting Relationships... | Kojones | General Discussion | 3 | December 17th, 2004 11:46 PM |
Relationships getting redefined? | raylitalo | General Discussion | 3 | December 15th, 2004 08:31 PM |
Disappearing relationships | Dan | Database Design | 2 | August 6th, 2004 06:43 AM |
Not seeing all relationships in layout window | jettabug | General Discussion | 3 | June 18th, 2004 05:42 PM |