Duplicate data

[COMP]

hi, i am trying to prevent duplicate data. i have a field called Targets and have 12 targets that any project can have. However i am trying to avoid end users to input the same target more than once for a particular project. Each target has a P.K and have set it to no duplicates, however it does not allow me to enter in the same target for other projects. Now i have resolved an issue like this by using seperate fields for each target which hopefully is not the only solution to this problem.

thanks

 

[neileg]

Create a two field index with the project ID and the target ID, set to No Duplicates.

 

[COMP]

Hi Neil thanks, how do i go about creating that?? Do i go on the Emries target tables?? If so i have gone onto the indexes icon and project ID and Target ID are both on there.......


thanks

Paresh

 

[neileg]

You have a one to many relationship between projects and targets. To model this you need a third table to hold the target ID, the project ID and any other information relating to that particular project target. That's where you implement the two field index. That third table could have its own separate PK or you can use the two field index as the PK since it will be unique.