I was watching thru the expert videos and notice that most of the forms was bound to Query and not Tables which is nice for calculation. But now I have this new problem which will not let me add new records because the Table is not in the record set. Pictures to follow. I'm sure I have miss up the join relationship.

If someone could point me to a video(s) that I need to watch to fix this problem. I have been trying to fix it for a week.