Thanks for the design tips, will add these and post results when done.
Trying to understand what can be done on the frontend side. Watched a few videos and this looks like what I want to implement. looks more of a way to semi secure the bones of the system and implement user privileges. there are 3 locations the tools/assets are stored currently, so this will be the churn out I guess. was thinking of a single board pc running win 10 and scanner/wifi on each location dedicated just for this purpose
Though not sue if it meets the employees onsite requirements. With the frontend I cant seam to see anyone running these on mobile devices android or from a webpage based system. after some looking am I correct in thinking that if the backend is a sql database on a server that this can be referenced from mobile apps and webpages ect.
its not a deal breaker though would be great if there is a real time central location for asset manuals/WMS ect that can be brought up in the field without a full blow pc.