Inconsistent results.. please help!

[vikghai]

Hello

I am working with a database where a subform does not save the child link. I have stripped the database of everything except the main form and subform, and I still get the same error. Sometimes the subform will save, and sometimes it doesn't (it appears that it will save only on the first attempt...).

If you can have a look it would be a great help. The form (frmarticles) contains the subform (subfrmArticlesAuthorship). When I select the author and then proceed to fill in the data in the main form, when I go to the next record and then back, the data in the subform disappears.

Any reasons why this is happening?

Thank you

[ItsMe]

I would use some VBA code to add records to tblArticlesAuthorship. The link between Master and Child fields will only be useful if there is already a value in the fields. You will need to include authorId to the new record in tblArticlesAuthorship.

[vikghai]

Thank you so much for the reply.

I am sorry but I am not too familiar with VBA coding. Can you point me to any sources so I can see a template of what you are suggesting?

Thanks again!

[orange]

I'm not following your post. But I do notice
there is no PK on tblArticlesAuthorship
and ArticleId and Authorid in that table are not required fields.

Your Main form is linked to your subform 1 to Many.
You must have a record in your MainForm befoe you can add a child record in the subform.

Update: I see there have been 2 posts since I read it and started to respond.

[ItsMe]

I do not see a need for table tblArticlesAuthorship. It is acting as a junction table but I do not see a need for it. I would add a column to tblArticles to be a Foreign Key for CV. Simply, store the PK from tblFaculty in tblArticlesAuthorship.

If you want to have a Main form/Subform, base your main form on tblFaculty. Your subform can display the many records in tblArticlesAuthorship. Doesn't solve the "adding records" thing but it will simplify the task.

[vikghai]

Thanks everyone for your input

1)I have this junction table as I have a many to many relationship between authorId and articleID
2) It looks like filling out the main form before the subform does the trick (without having to make anything required or adding a PK to the table)

I can move the subform so its at the bottom of the mainform, that way the user will hopefully not fill it out until they have filled out the subform. Is there any other more eloquent solution?

Thanks!

[ItsMe]

I suggest you concentrate on creating forms to enter data before you worry about viewing the data. Here is an example that creates a new record in the junction table. It is only an example. You will have to adjust it to suit your application.

The example is a form that views the existing records that represent articles. The user interacts with the form to create a new record in the junction table. This is only to provide you with an idea on how to approach the task of creating a record in a junction table. I can't imagine this form, by itself, would be a practical solution.