View Single Post
 
Old 04-06-2020, 10:17 PM
ArviLaanemets ArviLaanemets is offline Windows 8 Office 2016
Expert
 
Join Date: May 2017
Posts: 949
ArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant future
Default

From your example and from formulas on sheet DIREPs, it looks like DIREP is additional characteristic of document - parallel with DocClass. When this is the case, then you don't need additional sheet, but you need additional columns for DIREP indo in documents table.

At same time, from you having DIREP types listed in dropdown of DocClass, this assumes DIREP type are another document classes like release, training, etc. When this is the case, then a document can have only one of them selected - this means you need additional helper columns after column DCM in documents table. And again - no need for separate DIREP table.
Reply With Quote