Value based on if ID is present in another table (1 Viewer)

[Chumpalot]

Hi all,

I'm in the process of creating a database that keeps track of tokens and has the ability to link these tokens to users.

I have two tables, tbl_users and tbl_tokens.

tbl_users.AssignedToken is a lookup to tbl_tokens.TokenNumber.

When a token is assigned to a user I would like tbl_token.TokenStatus to have a value of 'Assigned'. If the token isn't assigned I would like this value to be 'Unassigned'.

I haven't the foggiest on how I go about implementing this. Any advice would be greatly received.

Thanks
David

 

[Minty]

If you have a field in tbl_tokens AssignedTo and store your UsersID then you don't need an assigned field. You know it's assigned because it has an assigned user ID.

 

[Chumpalot]

Thanks for the post Minty. This makes complete sense but I'm not sure on how to carry this out. Should I be using a lookup field?

 

[Minty]

Not in your table - they are evil http://access.mvps.org/access/lookupfields.htm
Just create a combo box on your data forms that use tblUsers as its record source.

 

[Chumpalot]

thank you. I'll look into this.