Hi

I have got a Login table and a staff table.
login table has got Staff_ID(PK) and a password field,
Staff table has got Staff_ID(PK) and all the rest.

I want to put this into visual basic but i dont know what relationship to make.
A one-to-one between the two tables
or
A one to many with the many side on the staff table with an extra field on the staff table?

Thanks

Paul

does it matter?

Guess it depends on do you plan to store only the current PW or the current + x many old passwords??

Hi

Thanks for replying,

I want to store only the current password and current staff.

Thanks

Paul

current password and current staff

Current == Current
Sounds like a 1:1 to me