Data Entered in form not ending up in relevant table

[mrnorth]

Sigh.. please help me out

I have a datasheet form linked to a query 'project entries' which brings together information from two tables. 'project' and 'project progress'. When the data is entered into the db all the data appears to be there in the 'project entries' query but not the 'project progress table where it should be. What have I missed out. All the reports link to the 'project progress' table so all the data must be in here.

 

[KenHigg]

Do you have the relationships set up correctly?

Ken

 

[mrnorth]

I'm sure I have. I can't see where I'm going wrong? I'm using the ManyToMany sample database (in the sample database forum) as I guide as it appears to be the closest type of 'sample' I could find to get my structure right.

Any suggestions?.... pls?

 

[KenHigg]

Hum... This does not appear to be a ManytoMany scenario. If you have one project record with many project progress records, wouldn't this make it a one to many?

Ken

 

[mrnorth]

The actual project table has a one to many relationship with the project progress table and the employee has a one to many relationsip witht he project progress table. That is the basic structure of it it seems. The database sample I found in this forum was called ManyToManyAXP.mdb and seemed to have a basic structure similar to mine which is why I'm trying to use it to understand mine.
It had three tables in relationships window with customers onetomany to bookings and venue onetomany to bookings.

 

[KenHigg]

I think that explains it then. You need a one to many project to project progress then a one to many project progress to employee.

I think this is correct...

Ken