Hi all ,
I am hoping for some guidance in structuring my database. I am having a hard time imagining/picturing how this would work without creating thousands of database tables in the system.
I am looking to build a membership system where USERS can log in and name their price on services from multiple SERVICE PROVIDERS. All is closed bidding. I would then like the SERVICE PROVIDERS to log in and view their bids and be able to hit a REJECT or ACCEPT button that the USERS can then relog in and see. There would be hundreds of service providers in each state. I\'ve looked at the Membership Tutorial and have started on some of the work but can\'t figure out how this will work without creating thousands of tables.
Any ideas or thoughts that I can feed off of? :shock:
Well maybe have different privileges set up so one table could be viewed by both but only give write privileges to the Service Provider??