many users editing same record diferent field

[mexicali2]

hi there is there a way to make 2 or more users edit the same record in the same free table but diffeent field... i have a simpe app for a local beauty contest there 7 judges and each one will have his one comp so maybe sometimes are in the same record but of course diferent field... TNX in advance

 

[Nigel Gomm]

probably best to keep the voting separate from the contestant's details and to put each vote as a new record in a different table. Then tally up the votes for display

e.g.

create table contestants (contestantid i autoinc, name c(250))
create table judges (judgeid i autoinc,name c(250))
create table votes (voteid i autoinc, contenstantid i, judgeid i, score i)

then insert each judge's vote into the votes table.

then you can

select sum(score),contestantid from votes group by contestantid into cursor (sys(2015))

perhaps add a category to the votes table so each judge can record a separate score for eveningwear, bikini etc.

this way you can easily add extra judges and categories.


hth

nigel

 

[mexicali2]

i'm doing some like that nigelgomm, just want to know if there's some way to do it more programless... tnx

 

[DSummZZZ]

To answer your original question, no. Only one user can lock and update a single record at a time.
You would have to keep track of which user is going to update a particular field, then lock, update and release the lock for each user who needs to update their field.
That sounds like much more of a programming nightmare than nigel's solution.



-Dave Summers-

Even more Fox stuff at:

http://www.davesummers.net/foxprolinks.htm