View Single Post
  #2  
Old February 4th, 2005, 04:10 AM
Duane Hookom
external usenet poster
 
Posts: n/a
Default

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