Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Saving a record that is keyed to relationship with another record

Status
Not open for further replies.

DBSSP

Programmer
Apr 1, 2002
327
US
Let me lay out some general structure.

Form1 - Main Record Info
Form2 - Required Info Related to Main Record, w linked fields from Form1
Form2b- Optional information linked to main record

Problem : The main record cannot be saved because the info disappears from the main screen causing Form2 fields to be blank. This info needs to be identical to form1, that's why they are linked. In the relationships, these tables are linked by a special number entered by the user.

When the user clicks save on Form2, they get an error stating the record doesn't exit in the table that Form1 is related to. Is there a way to change the relationship of the two tables so this doesn't happen, but still maintain the integrity of the data?

Jay [infinity]
"If the words up and down were reversed, would you trip and fall or trip and fly?"
 
Nevermind, I got. Guess I made the problem more complicated than it really is. Just overlooked the integrity controls, doh!

Jay [infinity]
"If the words up and down were reversed, would you trip and fall or trip and fly?"
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top