AnsweredAssumed Answered

Table Relationship Question

Question asked by dg3321 on Oct 18, 2010
Latest reply on Oct 18, 2010 by philmodjunk


Table Relationship Question


I have a table with projects from 2010 and a table with projects for 2011.  I have set the project names for each table to equal each other in a relationship.  I have also set certain basic information on the 2011 table to equal it's 2010 equivalent (as a related field).  Certain projects from 2010 will continue into 2011.  On the 2011 table when i enter the project name, the related fields then are set with the correct information from the related fields in 2010.

Here is my question: How can i set this up so i am allowed to create new projects in the 2011 table.  It won't allow me to do this b/c of the related fields i have set.  I can, however create new records when i check the 'allow creation of new records via this relationship' in the 2010 field relationship settings.  The only problem is that then all of the new projects for 2011 are now appearing in the 2010 table.

Is there a way around this?