> I have an application I've written for a pet sitting service. So
someone
> calls and says they need a pet sit and we take their info and pick a
> sitter.
> We call that sitter to see if they can take the job, but if they say
no,
> then we have to change it to a new sitter who can take the job. I
Not usre how your db is designed but I would probably just add a table that
links to the sitter and job tables. As people are called a row is put into
this table with the sitter and job ids and an 'accepted' column is set to 0,
or 1 or Y or N. Then you can query the job table and join the sitter
2 matches
Mail list logo
