Problem with updating form

[topgeek]

Hi There,

I have a form which I cannot update.

It consists of contacts details held in tblContacts, the organisation the contact belongs to held in tblOrganisation and a projects table which displays the projects associated with each organisation. Notes attched to each contact in a subfornm from tblNotes.

The problem is that I cannot add a newproject on my form - I just get a beep - no error message.

My tables are linked as follows:

tblNotes Pri-ContactID linked to ContactId in tblContact
tblContact Pri-OrgID linked to OrgID in tblOrganisation
tblOrganisation Pri-ProjectID linked to ProjectID in tblProject

Have I got the realtionships right?.

One thing I notice is when I drag the fields between the tblOrganisation and tblProject the many side is on the organisation side where I want a single organisatiion to have multiple projects.

Could anyone please help?

 

[Remou]

Hi
I think this should be set up as follows:
[tt]tblOrganisation
OrgID

tblProject
ProjectID ) If there are lots of projects, these
Pri_OrgID ) two are probably your Unique key

tblContact
ContactId
Pri_OrgID

tblNotes
NotesID
Pri_ContactID[/tt]
I hope I have got your point.
PS Access is not mad about dashes in field names!

 

[willir]

Consider simplfying things.

Read the following...
Harnessing the Power of Updatable Queries

Richard