Dear all
I need to create a Bill Of Material (BOM) in MS access but there is some issue want to discuss first.
The product will be created with an Assembly of 5 accessories, there will be two branches with the same product code but when we stock out or send it to manufacturing the stock...
1- =[tblInventoryTransactionSubForm].[Form]![Text83]
getting error on this
2- also want to know that is it possible to make like data validation in excel.
if possible can create error or pop up windows on validation.
Dear All,
Thanks for all the support given.
i need to create an Access database where i can do as follow :-
Products - can be purchased than make reserved for some project & if required to sale will be deducted from the stock.
Current Stock Qty = Purchase - Reserved (too deducted from...
adding two query in one but getting duplicate records.
SELECT [qryReserveFolio Query].Product, [qryReserveFolio Query].Qty, qrySalesFolio.Qty
FROM [qryReserveFolio Query], qrySalesFolio;
can anyone help, as its showing duplicate values/ rows