adding records using referenced or linked information? (maybe a bad title)

[Tuckejam]

I am trying to replicate a NOTES feature that we use in the company DB at my work.



We have Jobs that have JOBNAME and JOBNUMBER, and there is a JOBNOTES form for storing notes

The Main JOBNOTES form has two smaller Subforms
The top subform is where you would enter the new note and click add
and the bottom subform is the history of all of the previous notes for that job that you can scroll through

and all of the notes for all jobs are saved in the same tblProjectNotes
(I took the image below from the work DB hoping someone here can help me figure out how it works)



I cant figure out how it is automatically designating the JOBNUMBER or PROJECTID when saving the note by clicking ADD.

I built my own (much less pretty) version at home, and the lower part on mine works fine,
I just used a qry that references the JOB/Chapter that the form i showing and it only displays notes for referenced information

but I cant get the ADD notes part to work.
any way I try to reference or pull the information for the job(chapter) that I am logged into causes a problem when trying to "ADD" the note

I get and error that states

"You cannot add or change a record because a related record is required in the table 'tbl_Chapters'

See image below



Any thoughts or ideas would be greatly appreciated.

THanks

[Welshgasman]

If that was mine, then I would have an autonumber ID that identifies a Jobname and JobNumber, but it really depends on your data structure.? If te jobnumber was unique, then it might be that.
The table where the job is held would be the parent and the notes table the child table.

You cannot add a child record before you add a Parent record.? In your case it appears to be tblChapters record?

[Gicu]

Is the frm_ChapterNotesNew_sfrm linked to the main form via the master\child field ChapterName. If you set it as Data Entry=Yes and link it that should be all that is needed (you shouldn't need a textbox for the author as it should be coming from the logged on user on the main switchboard).

Cheers,