A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Database Design
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

"You can't add or change a record because a related record..."



 
 
Thread Tools Display Modes
  #1  
Old July 20th, 2006, 03:39 AM posted to microsoft.public.access.tablesdbdesign
bird lover
external usenet poster
 
Posts: 65
Default "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  
Old July 20th, 2006, 04:21 AM posted to microsoft.public.access.tablesdbdesign
bird lover
external usenet poster
 
Posts: 65
Default "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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

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


All times are GMT +1. The time now is 08:03 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright 2004-2024 OfficeFrustration.
The comments are property of their posters.