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.
In ur stockdetails table create "Date" field
Then stockDetails table directly link to Datum table.
KeyPart As %KeyPart,
StockDate as Date
Date As %date,
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.
Retrieving data ...