we are looking for somebody to produce a database either in xcel or access
we manufacture products using sourced components (25 or so components of various amounts make one of our devices, these include nuts and screws etc...)
we are trying to keep a check on what components are used when we build one device to make sure we don't run out of components.
if possible it would be great to have a small ordering section where if we order multiple things from one supplier then it will pull out what we need to order with order codes, this is where perhaps access may be better.
one table would show the individual components with their stock numbers
we know that from these components it takes a certain amount to make one device
we would like when we update the completed item database that the stock control of components should decrease
when levels hit low then we should be notified or the level change to red
we would like it also to have a basic CRM system perhaps attached for invoices
somebody may have this type of system already built and feel they can simply modify it to suit our needs
thanks for viewing and any questions please ask
Hi,I have read all your requirements and I can do this job very professionally and you will get Pro Quality [url removed, login to view] we will work until your 100% Satisfaction please visit my profile portfolio for my work. I just have Daha fazlası