Web based database on premise
We have a spreadsheet we use to track information that has 15 or so fields. We keep a separate sheet for each site and managing these has become cumbersome. I am looking to put this into a database. I don't like access although it would do the trick I would like something web based for easy access. I look at online database builders like ZOHO and they are very good and do what I am looking for. however I don't like the monthly pricing models and the data stored online. I would prefer storing the data on our SQL server. I have looked at microsoft lightswitch ... its okay but really confusing to work with compared to the builders i found online.
Suggestions?
Suggestions?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
We could probably whip up some scripts and table creations in a matter of minutes but I think he wants some more control over it as well as concurrently develop a solution that users can interact with which is what ZOHO is currently providing him.
Hopefully the Author gets back to us soon with some more information.
Have a great week everyone!
Hopefully the Author gets back to us soon with some more information.
Have a great week everyone!
ASKER
That is correct. I know how to create the tables and work with them in lightswitch. however adding search functions and user logon permission etc... are the missing pieces.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Okay this is kind of changing to a lightswitch help case. but the other problems I have is creating relationships. My data is stored in SQl ... I have 2 tables. I just want t a simple link between the 2 so that a field (site name) is link to the other table ...so any records for that site are linked together.
the issue is it wont allow a link on a field that is not a key field. Each table has its own auto incrementing ID but of course that will not work. I assume that perhaps I need another separate table with just sites and a unique ID associate with each one and then from there create my linked table?
the issue is it wont allow a link on a field that is not a key field. Each table has its own auto incrementing ID but of course that will not work. I assume that perhaps I need another separate table with just sites and a unique ID associate with each one and then from there create my linked table?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
okay so let say I have done this. And now i have another table where I want to reference the site information... this is where I am not understand. How does the site ID ... which is incremented and automatic key get populated in the table. users need to be able to create this link by choose a customer and those ID's would be meaningless to them
I can help you with the SQL side of things but not specific to lightswitch. You might need to open a new question on Lightswitch to attract some experts who know that software in depth.
With that said, let me take a crack at at least the logic side of things. I'm going to make some assumptions about the power of Lightswitch in handling things like this.
I'm going to use your customer information example. If you wanted to make a form that created a new customer, you would maybe have a dropdown that includes the names of location codes or whatever from the site list table and have the user select that. And, based on the selection of the user, your would build the logic in the form that "Company A" is the same as site_id 1. So, when the form saves the customer record, in the site_id field for that customer it would substitute the user input "Company A" for "1".
Does that make any sense? If it doesn't, I apologize. You sound like you have a good head on your shoulders and with some pointed direction or some videos on the subject to provide some training you could knock this out.
With that said, let me take a crack at at least the logic side of things. I'm going to make some assumptions about the power of Lightswitch in handling things like this.
I'm going to use your customer information example. If you wanted to make a form that created a new customer, you would maybe have a dropdown that includes the names of location codes or whatever from the site list table and have the user select that. And, based on the selection of the user, your would build the logic in the form that "Company A" is the same as site_id 1. So, when the form saves the customer record, in the site_id field for that customer it would substitute the user input "Company A" for "1".
Does that make any sense? If it doesn't, I apologize. You sound like you have a good head on your shoulders and with some pointed direction or some videos on the subject to provide some training you could knock this out.
ASKER
Yes that does make sense ... I just have to figure out how to apply all this in lightswitch... your right a may need to open a separate case.
Hopefully this has helped you at least answer your initial question. I think you have the right tool. It should be able to do everything you need to do based on my reading on the subject.
ASKER