Portal problems NEED help plzzzz

[TougToug]

Hi, i am quite a Newbie in FM (using FMP7) and i am building a database for design and production validation testing in a Vehicle company.

I have many tables (see attached) and i want to use 3 Main Layouts (Lab Data, Projects sheets (parts, test)

The way i want it to work is as follows:

Engineers will create a new project and feeding the parts No, tube, connectors, etc...

Then create a list of Test to be done with all the details

Ideally i would like to create a matrix (like Excel spreadsheet) matching which test as to be done on which part or tube or connector

And at the other end, i will have the Lab guys feeding the results in the Lab Data layout

As you can guess from the title, i have issues with portals with weird behaviours

and also auto-entry calculation for fields problems

If anyone could help me ( i'm sure there is a mess in the relationships, might need more tables or less i don't know anymore ) that'd be greatly appreciated

Thanks

TestVerificationDatabase.zip