469,082 Members | 1,091 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,082 developers. It's quick & easy.

How to edit "linked" tables?

I have table: tblProj
Proj_ID
Proj_Name

I have table tblOrg
Org_ID
Org_Name

I have table linkProjOrgtable 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@kleinosky.com
May 28 '10 #1
1 2638
ChipR
1,287 Expert 1GB
If I understand you correctly, the query is redundant. You could set your subform to linkProjOrgtable instead of the query. You should be able to add or delete records in the subform.
May 28 '10 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

5 posts views Thread by Nick Stansbury | last post: by
1 post views Thread by mr_doles | last post: by
3 posts views Thread by ivanov.alexei | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.