Hi Team
I need a bit of help once more if anyone would be kind enough to have a look at this.
I have a table called Managers and Clubs with the following fields
id
managerid
clubid
startdate
enddate
It keeps records for the manager history of a club
I have a table called Matches with these (relevant) fields
matchdate
clubid
managerid
When I leave the clubid field, I would like to get the manager id automatically from the managers and clubs table where clubid matches and matchdate is between startdate and enddate.
If the relevant record doesn't exist I would like to display a message to that effect
I want the managerid to then be stored in the matches record
It is probably one of those that is very straightforward but I am getting in a bit of a mess with it and not now thinking clearly !!!
Any help would be very much appreciated
Phil
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (1) |
Tidak ada komentar:
Posting Komentar