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
|
|||
|
|||
"You can't add or change a record because a related record..."
Database created in 1994. I renamed original table [primary] as [primary old
7-18-06] because garbage got into one bad record which could not be deleted. I appnded good records into new table called [primary]. [Primary]![id_primary] in form "Mother" is linked to [Rolodex]![rolodex_primary] in subform "Child". Get above error which states, ..."a related record is required in table primary old 7-18-06". My recollection of fifteen years ago, I attached [Rolodex]![rolodex_primary] to [primary]![id_primary] by dragging one field to another. I also attached a dozen or so other tables to [primary]![id_primary]. I forgot how I did it, but it was similar not the same as attaching multiple fields from different tables in query design. My recollection is the design looked like a spider with the body being primary and each leg had another table at the body. It's similar to Vann diagrams, a term sometimes used to describe relationships. I am not a programmer. I now use Access 2000. |
#2
|
|||
|
|||
"You can't add or change a record because a related record..."
I found information about relationship and found the diagrams. I don't want
to waste anyone's time on this question. "bird lover" wrote: Database created in 1994. I renamed original table [primary] as [primary old 7-18-06] because garbage got into one bad record which could not be deleted. I appnded good records into new table called [primary]. [Primary]![id_primary] in form "Mother" is linked to [Rolodex]![rolodex_primary] in subform "Child". Get above error which states, ..."a related record is required in table primary old 7-18-06". My recollection of fifteen years ago, I attached [Rolodex]![rolodex_primary] to [primary]![id_primary] by dragging one field to another. I also attached a dozen or so other tables to [primary]![id_primary]. I forgot how I did it, but it was similar not the same as attaching multiple fields from different tables in query design. My recollection is the design looked like a spider with the body being primary and each leg had another table at the body. It's similar to Vann diagrams, a term sometimes used to describe relationships. I am not a programmer. I now use Access 2000. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Office 2003 Standard MultiLingual User Interface (MUI) installation | [email protected] | Setup, Installing & Configuration | 3 | May 23rd, 2006 11:59 AM |
change colors on selected record | Ricoy-Chicago | Using Forms | 1 | August 5th, 2005 08:46 PM |
Looking up a related record in a related form | Jim Normile | Using Forms | 0 | November 3rd, 2004 04:46 PM |
Updating field on a record that has related records. | David Andrews | General Discussion | 3 | June 10th, 2004 10:16 AM |
Form Doesn't Go To New Record | Steve | New Users | 15 | May 16th, 2004 04:33 PM |