I want to ask for a professional opinion on a project I am working on. I have two clients that I update the content for on their site. Both sites use similar information & to prevent double entering it, I have a Access DB set-up and I simply copy the information needed to the second client via code. I would like to make it where they can now edit the information themselves online (or at least one of the clients since they now have a more tech-savy emp). Anyway, I was thinking of creating a shared db for the two clients & simply limit access to certain fields and preventing either from deleting information that the other one would need. I would still like to use WP for the CMS and simply add a plug-in or widget for the client’s to access this information. Does anyone have any ideas?
Client 1 ~ Movie Theater
Needs
~Enter movie details (shared info)
~Enter & maintain showtimes
>must have expiration date as well as publish date
>needs a calendar or search option for future dates
Client 2 ~ Movie Rental
Needs
~Enter movie details (shared info)
~Movies need to show or hide based on DVD release date
Any feedback would be appreciated.
