Hi, everyone.
Attached is a test database. In it, there are three tables:
1. Ontologys - A list of categories a product can belong to. This is a linked table in my production database. I cannot alter its structure.
2. tbl_ImageReferences - A reference number and associated required images for that reference.
3. tbl_ImageRequirements - The list of ontologys (categories) and the reference assigned to it.
The idea here being that for any given product category, a set of images is required for all products in that category.
I have a datasheet form (frm_ImageRequirements) where I want to edit the ontologys and the references. In effect, I want to be able to edit tbl_ImagesReferences and tbl_ImageRequirements in one form. I need to keep it as a datasheet. What I want to achieve in this form is for the user to see all ontologys regardless of whether or not a reference is assigned to it. I want the user to be able to edit the reference number and I want the user to be able to edit the images required for that reference number. My current form does all of that. What it cannot do is add a new reference or delete reference in the tbl_ImageReferences table.
Can I achieve what I am asking in one datasheet form?
imagestest.accdb
Thank you,
jj