Hi,

i have designed a stock control database for a project.

I have a table called Stock (holds number of items in stock) and one
called items (all the items details such as supplier and minium stock)

Well, the same item cant appear twice in the stock table or the items
table so i want to create a one to one relationship. However access
2000 will only let me create a one to many relationship

how do i do a one to one relationship in access 2000?

Many thanks

Thanks,

i managed to work out how to do a 1 to 1 relationship. I made the
attributes within my two tables indexed with no duplicates. this
solved the problem!

I wanted two tables to keep it tidy, but its a college project so im
still learning


Thanks