Hi:

I have a populated table like this:

http://i1272.photobucket.com/albums/...ps0a08ab6e.png

I have been looking for problems in making good use of table information, and I have identified the follwing ones:

  • Someone could be assigned to a third or fourth activity.
  • There is no an unique identifier.
  • There is not a precise list of activites (for example, food preparation and cooking, transport and driving)
  • Searching logic can be messy and hard to maintain:


Code:
IF contribution == "cooking" OR contribution2 == "cooking" OR ... OR contributionN == "cooking"
Can you foresee another ones?

Thanks in advance.