How to create the same ID automatically for two tabels?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi!

I am trying to build a database where visitors on my website can submit
there photos. That is easy. The problem is that I would like them to get the
opportunity to vote for the pictures also. I guess I need two tabels one
where the results is shown and another where the counting of the average
result is done. The problem I have is that I can't figure out how the
database knows how to find the right score for the right picture. All help I
get on this matter is more then welcome. I am a real beginner with Access.
Thanks in advance!
 
Each photo should have a unique ID attached to it. Then your voting table
would have one field: the picture ID. Enter a new record in that table for
each vote, using the picture ID.

You then can sum the occurrences of a picture ID to get the count (vote).
 
Back
Top