|
-
December 1st, 2008, 09:01 AM
#4
Re: determin relationship between two tables?
So you need 3 Tables
Users
Restaurants
RestaurantsSelected (by Users)
Users Table
UserID
UserName
UserDetails etc
Restaurants table
RestaurantID
RestaurantName
RestaurantType
RestaurantStarRating
RestaurantDetails etc
RestaurantsSelected
RestaurantID
UserID
DateSelected
RatingGiven
UserComments etc
Thats it
A user logs in (Opens User Table)
A user selects a restaurant they like from a list (or even add a new restaurant to the Restaurant Table)
When they click "VOTE" button, you write out a record to the RestaurantsSelected Table along with user comments and Rating Given
From time to time you run a process which adds up all the votes per restaurant and turns it into a STAR rating in the Restaurants File
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|