Not sure how it being for charity is relevant here?johnj wrote:1) as this is a charity event, link to a folder is good.
Thinking about it would it be better to have a day table, a room table, a person table, and a file table and add to each as needed, or just two tables you sugested (or have I missunderstood what you are saying)?johnj wrote:3) each person/room/date as a separate field with a 1 for each for each picture is the right way.
Key1,person,room should be in one table and in the other table it should be key2,key1 ,date,link to picture
....not sure how it being for charity is relevant here?
johnj wrote:....not sure how it being for charity is relevant here?
Usually this sort of sites are temporary, I mean for one event in a year. Also, people involved in this charity are likely to be local people. Hence, we do not need a highly secure site by saving pictures in a database. But if you have the time and money go ahead and save all pictures in a table.
Users browsing this forum: No registered users and 2 guests