This seems like it should be easy.... My inventory table has fields for catalog items(text) and additions (number). A second database list suppliers with fields for the same two items. I want to enter manually the text and number in the supplier database and have it automatically posted in the inventory DB table so the inventory additions refer to the correct catalog item.The additions then need to be added to existing inventory.
Tnanks in advance for anybody that can advise.
I would suggest reading the first five in the list here.
Products is a Table
InventoryLevel is a Table
Invoices is a Table >--< InvoiceLineItem is a Table >--< Products
PurchaseOrder is a Table >--< POLineItem >--< Products
The design can be done in several ways