Data editparadox

[Wulf13]

My problem is this:

Table 1 contains: PIN, Name, Section
Table 2 contains: Name, Section, ID
Table 3 contains: ID, project name

Table 1 is current personnel, table 2 is personnel who've worked on a project, table 3 is a project listing.

I'm trying to create a way that when a record from table 1 is displayed in my form, info from table 2 can be updated and in turn update info in table 3. I've tried several different join queries but after each one, they make the data un-updateable.

I know table 2 is basically a redundant table but I need it to store the data for history purposes.

 

[MarkK]

Consider the following structure...

Table 1: PIN, Name, Section, OtherPINInfo
Table 2: LinkID, PIN, PID, OtherInfoAboutPIN'sRelationshipToPID
Table 3: PID, project name, OtherPIDInfo

Tables 1 and 3 have One-To-Many relationships with the linking table 2. This is a classic Many-To-Many relationship.
PIN's Name and Section are not duplicated and all data has it's distinctive home table.
Is easy enough to show the many PIDs that PIN has worked on, or the different PINs working on a PID.
Is easy enough to store data only related to the relationship between a PIN and a PID (table 2).

 

[Wulf13]

Thanks lagbolt, I'll give it a shot. I think a new approach to this matter is needed, like you suggested