Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello, please check out my datastructure.
I want to use the 'Datum' table with the dates also for StockDetails. How can I use the datum table for both tables?
MonthlyStockFinal contains a summary of the StockDetails for the end of each month. in StockDetails the StockDate field contains the date.
You can create a new fıeld with "date+keypart" in both stockdetails and monthlystokdinal tables.
Hi
In ur stockdetails table create "Date" field
Then stockDetails table directly link to Datum table.
see below..........
StockDetails:
Load
..
..
KeyPart As %KeyPart,
StockDate
StockDate as Date
From.....
MonthlyStockFinal:
Load
Date As %date,
KeyPart As %KeyPart,
KeyPart,
EndOfMonthStock
From....
I tried this but I get Syn keys. Because of KeyPart
You can create a new fıeld with "date+keypart" in both stockdetails and monthlystokdinal tables.