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 wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

two subforms. message related record required

Status
Not open for further replies.

keiserc

Technical User
Feb 24, 2004
16
US
basic. three tables. contract & equipment & notes.
all linked by contractID on contract table. Form based on contract with two subforms. equipment & notes. As long as I only use 1 subform - works great. when I add the second I get the message, "cant add or chage record because related record is required on contract table. I don't understand - they are linked thru the autonumber field contractID. What do I need to do to fix the problem? plain english, step by step please, do not understand all the programming terms yet. (equipment & notes are set up identical)side by side subforms - so each can grow/shrink as needed. Just can't use them both???
 
keiserc . . . . . . . .

What are the [blue]Relationships[/blue] as they appear in the [blue]Relationships Window[/blue].

[Purple]This is the key to solving your problem![/purple]

cal.gif
See Ya! . . . . . .
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top