J
James
This may get a little complicated so please bear with me. I am new to Access
but I need it for a new position at work. I have been working on a database
and for the most part it has gone very well. The more I think about it the
more I add and want to keep adding. So here is what I would like to do.
Please let me know if it is possible. I want to create one database for
orders from my customers, my inventory, my orders to my vendors to have the
parts made, receiving parts in form my vendors and finally shipping them out.
I would like this to all work together for the most part. I would like to
receive an order and log it in and as I enter the part number my customer
ordered it would go to my inventory and say you need so many, then my
inventory would calculate and say I have so many in stock, so many on order
and I now need to order so many more. Then when I place an order with my
vendor it would go to inventory and show parts on order. Then when the parts
come in I would like to receive them in and have the inventory updated. Then
the final thing would be ship the parts and have the customer PO closed and
the parts inventory updated. Now I know this is a lot for a beginner like me
but I already have a good start. I am having trouble linking some of the
data. All transactions would have a common job number to relate them. I would
also like to flexibility to send a vender PO wit out a customer PO just
incase of rework or a spot op. So any ideas, suggestions or advice would be
much help.
Thank you.
James
but I need it for a new position at work. I have been working on a database
and for the most part it has gone very well. The more I think about it the
more I add and want to keep adding. So here is what I would like to do.
Please let me know if it is possible. I want to create one database for
orders from my customers, my inventory, my orders to my vendors to have the
parts made, receiving parts in form my vendors and finally shipping them out.
I would like this to all work together for the most part. I would like to
receive an order and log it in and as I enter the part number my customer
ordered it would go to my inventory and say you need so many, then my
inventory would calculate and say I have so many in stock, so many on order
and I now need to order so many more. Then when I place an order with my
vendor it would go to inventory and show parts on order. Then when the parts
come in I would like to receive them in and have the inventory updated. Then
the final thing would be ship the parts and have the customer PO closed and
the parts inventory updated. Now I know this is a lot for a beginner like me
but I already have a good start. I am having trouble linking some of the
data. All transactions would have a common job number to relate them. I would
also like to flexibility to send a vender PO wit out a customer PO just
incase of rework or a spot op. So any ideas, suggestions or advice would be
much help.
Thank you.
James