Help me think this through. It's been a while since I have done any Access development
I have a parent-child form that shows publishers (the parent) and all the associated publications (the child). The form and sub-form are joined with the PublisherID field. Right now we have pretty much the whole set of Publishers and the whole set of Publications, we just don't have many of them associated with each other, i.e. the [Publications].[PublisherID] field is null. I want the user to be able to add and delete the associated publications for each publisher from the sub-form. I DON'T want them to add and delete publication RECORDS from the sub-form. Essentially I just want them to be able to edit the PublisherID field of the Publications records listed in the sub form.
I'm not finding a simple solution to this, which usually means that I'm approaching it all wrong.