I have 3 tables. 1 has a field "itemNumber" only.
The other "tblGovEst" has 8-9 fields, one of which has a cbo based on the tbl "itemNumber". It also has a field called "ID".
The 3rd "tblMain" has many fields, one of which has a PK called "ID"
When I use my main form, (source=tblMain), I link my subform (source=tblGovEst) using ID + ID
The user doesnt see field ID from either tbl while filling out the forms.
My question is:
Each record in my main forms subform can only have any given itemnumber once, but any given project can have any one of the itemnumber.
When I try to set an index so the user cant use the same itemnumber more than once for a project, Access gives me a message that it cant do it because it would create duplicates.
Im posting the 3 tables so someone can look at them for me.....data is already in the tables....
The other "tblGovEst" has 8-9 fields, one of which has a cbo based on the tbl "itemNumber". It also has a field called "ID".
The 3rd "tblMain" has many fields, one of which has a PK called "ID"
When I use my main form, (source=tblMain), I link my subform (source=tblGovEst) using ID + ID
The user doesnt see field ID from either tbl while filling out the forms.
My question is:
Each record in my main forms subform can only have any given itemnumber once, but any given project can have any one of the itemnumber.
When I try to set an index so the user cant use the same itemnumber more than once for a project, Access gives me a message that it cant do it because it would create duplicates.
Im posting the 3 tables so someone can look at them for me.....data is already in the tables....
