Forums
This topic is locked
Need general advice on the best way to do this....
Posted 10 Apr 2002 11:28:46
1
has voted
10 Apr 2002 11:28:46 Jason Tandy posted:
Howdy all,I need some general advice on the best methods that would achieve the following:
I have an Online Memorial site that I am rebuilding in asp.
I would like to offer a service to my local funeral directors, where they can create as many memorials as they like, at their leisure.
The way I foresee it working is each Funeral Director will be assigned an ID number along with a password that they enter to get into the Memorial creation section on my site.
When they create a memorial it will store their ID in the table, so that at a later date they can come back and view/edit/delete any of the memorials they have created.
Now can this be done, so they see their memorials only and nobody elses?
If so what would the best way to go about it?
Any advice would be greatly appreciated.
BM
Replies
Replied 10 Apr 2002 12:23:25
10 Apr 2002 12:23:25 Andrew Watson replied:
This is relatively simple bluemidget, what you need (in simplest terms) is a database with two tables..tblFuneralDirectors and tblMemorials.
tblFuneralDirectors should contain...
FuneralDirectorID (Autonumber)
Username
Password
[plus any other info on funeral directors]
tblMemorials should contain....
MemorialID (Autonumber)
FuneralDirectorID (Number)
[plus any other info on memorials]
these tables should be linked by Funeral DirectorID. Therefor you have a table where a funeral director can have as many memorials as he likes.
Then your site should just filter memorials on the ID of the funeral director....
This is made easy if thought is put into the database.
tblFuneralDirectors should contain...
FuneralDirectorID (Autonumber)
Username
Password
[plus any other info on funeral directors]
tblMemorials should contain....
MemorialID (Autonumber)
FuneralDirectorID (Number)
[plus any other info on memorials]
these tables should be linked by Funeral DirectorID. Therefor you have a table where a funeral director can have as many memorials as he likes.
Then your site should just filter memorials on the ID of the funeral director....
This is made easy if thought is put into the database.
Replied 10 Apr 2002 13:02:20
10 Apr 2002 13:02:20 Jason Tandy replied:
That sounds perfect.
Many thanks for your time.
BM
Many thanks for your time.
BM