How to edit "linked" tables?

[matthewra]

I have table: tblProj
Proj_ID
Proj_Name

I have table tblOrg
Org_ID
Org_Name

I have table linkProjOrgtabl e which is to link 1 or more orgs to a project
linkProjOrg_ID key)
Proj_ID
Org_ID

I made
Query
Q_linkProjOrg
which has 2 tbales linkProjOrg and tblOrg and relationship from linkProjOrg.Org _ID to tblOrg.Org_ID
(show all linkPrjOrg records and only tblOrg where theya re equal)

I made form FORM1 with fields form tblOrg and subform
SF_linkProjOrg (subform uses Q_linkProjOrg) and connects by Proj_ID

So, when I display Form1 it correctly shows each project (tblProj record) and as I scroll through each project it shows all linked orgs for that project.

How do I make something so I can for any project selected - add or delete a new record in linkProjorg - that is for any tblProj record I want to link a new OPrg or delink a linked Org ...

matthew@kleinos ky.com

[ChipR]

If I understand you correctly, the query is redundant. You could set your subform to linkProjOrgtabl e instead of the query. You should be able to add or delete records in the subform.