Relationship question

[mjwakema]

Hello, I am trying to learn Access 2013 and to do so I am setting up a simple journal. I have 3 tables. The MyJournal has foreign keys to the attachment table and the DateEntered table. I separated out the attachments and the date as I will have many dates for each journal entry and may or may not have an attachment.

When I create a query (MyDate, JournalEntry, Attachments) I can open the query and enter a new date, but I cannot enter anything into the JournalEntry field. I keep getting the same error. "The value cannot be added to this new row until the row has been committed. Commit the row first, and the try adding the value." If I go to a new record and then come back, then I can enter a text into the journal entry.

Have I set up my relationships correctly?

Thank you for the support!

Mike

[John_G]

Have I set up my relationships correctly?

If each journal entry (in MyJournal_TBL) can have many dates, and each entry can have zero or one (or more?) attachments, then your relationships are reversed, and use the wrong fields.

Attachments_TBL and DateEntered_TBL require the field MyJournalID as a FK to MyJournal_TBL, and the relationships have to be defined using that field.

I strongly suggest that you do not try to use a query for entering data; instead use a form - subform arrangement, which is one of the commonest ways of working with one-to-many relationships.

[mjwakema]

Thank you for the response. I used the query as an example. I was having the same issue with a form. I was leaning in the direction that I have something backwards but was struggling to fully understand it. I will switch these around. Again, thank you.

Mike

[mjwakema]

This work and it makes so much more sense then what I was doing.

Thank you

[orange]

wrong post -sorry