Linking database fields
New to this and am trying to create an invoice that can have a link between part numbers and items on invoice database to inventory database so when I type in the part number on the invoice it will reference the inventory database and also reduce the inventory amount reflecting the amount sold on invoice for stock control.
I hope this is a clear enough description of what im trying to do but if not I will try again on later posts..
I am using the trial version to make sure I can achive what I need it to do before I purchace it..
Hope someone can help as it would be greatly appreciated.