Need help with MS Access
Hi,
I am triing to create a simple chat and I want each user to have an avatar. So I was wondering if it was possible in Access to link the field "avatar" of the table message with thus of the table "users"? I already tried alot of trics but avatar index is not updated in table message when I change it in table users.
Hope somebody understend what I meen ;)
goast
[450 byte] By [
goast] at [2007-11-11 7:52:22]
# 1 Re: Need help with MS Access
Your english was not clear however from what I can gather you are implying the following:
You have a User table and another table for storing Avatar's. You want to associate the avatar tables' record with a particular user record.
To do this you need to create unique keys for each record, such as AutoID or RecordID or something similar and use Auto Increment (or produce your own sequencial numbering format/system).
Then you would need a field in the user tables' record to associate with the avatar. I would suggest called this AvatarID or similar. Then to associate, insert the unique Avatar ID with the user record.
