access table

[accessprobs]

hi,



i am designing a database using access and my question is if i want to create a unique field called role id which can contain unique another field called contract role id and it should roll off if that particular role id expires or something.

how can i do this.

[Stingaway]

Could you be more vague?

Define "roll off if that particular role id expires - or something"

[accessprobs]

oops sorry !

like i have a column role id but when a person leaves that id and another person joins that role there is some clashes.

how can i resolve this problem

[Stingaway]

First thought is that if a person leaves, that particular role becomes inactive for that person. You could then adjust your queries / reports to look for occurrences of the particular role in question based on an active or inactive flag.

[orange]

hi,

i am designing a database using access and my question is if i want to create a unique field called role id which can contain unique another field called contract role id and it should roll off if that particular role id expires or something.

how can i do this.

Here's a link to a document that will help with database design.
http://forums.aspfree.com/attachment...achmentid=4712

It seems from your info that a person "occupies/has" a role from a start to some end date. These would seem to be important attributes in your table.

Also, it is recommended that you do NOT have names with spaces or special characters.
Good luck with your project.