Linked Tables: different sub layouts with same fields
Goal
Find a way to implement different SUB Layouts:
with the same fields:
FILD_CLASSIFICATION_1
FILD_CLASSIFICATION_2
FILD_CLASSIFICATION_3
FILD_CLASSIFICATION_4
FILD_CLASSIFICATION_5
FILD_CLASSIFICATION_6
but different Names (translated) for each Layout:
This when Customer has different properties for different Parts.
Example
case 1)
Save a SWX Part
Dataentr.lst → CATEGORY1 = "XX"
or Field MAKE_BY = "MAKE"
shows this fields:
ID
Description
FILD_CLASSIFICATION_1
FILD_CLASSIFICATION_2
FILD_CLASSIFICATION_3
FILD_CLASSIFICATION_4
FILD_CLASSIFICATION_5
FILD_CLASSIFICATION_6
BUT Translated:
Number
Benennung
Fieldname_XX
Fieldname_YY
Fieldname_ZZ
case 2)
Save a SWX Part
Dataentr.lst → CATEGORY1 = "YY"
or Field KAUF MAKE_BY = "BUY"
shows this fields:
ID
Description
FILD_CLASSIFICATION_1
FILD_CLASSIFICATION_2
FILD_CLASSIFICATION_3
FILD_CLASSIFICATION_4
FILD_CLASSIFICATION_5
FILD_CLASSIFICATION_6
BUT Translated:
Number_EIGENFERTIGUNG
Benennung_EIGENFERTIGUNG
Fieldname_XX_EIGENFERTIGUNG
Fieldname_YY_EIGENFERTIGUNG
Fieldname_ZZ_EIGENFERTIGUNG
A solution
A possible solution is through linked tables and field translation thanks to SQLServer View:
; DBWLinkedTablesDef.TXT
;
; DBWorks Linked Database Tables Definition File
;
;--------------------------------------------------------------
; "<table name>","<primary key>","<DOCUMENT table access key>"
;
"NORMTEILE","NR","NR"
"KAUFTEILE","NR","NR"
this is the SQL code:
/****** Objekt: View [dbo].[KAUFTEILE] Skriptdatum: 12/04/2009 16:43:54 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER VIEW [dbo].[KAUFTEILE]
AS
SELECT NR, T, KATEGORIE1 AS K1, KATEGORIE2 AS K2, KATEGORIE3 AS K3
FROM dbo.DOKUMENT
/****** Objekt: View [dbo].[NORMTEILE] Skriptdatum: 12/04/2009 16:44:13 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER VIEW [dbo].[NORMTEILE]
AS
SELECT NR, T, KATEGORIE1 AS N1, KATEGORIE2 AS N2, KATEGORIE3 AS N3
FROM dbo.DOKUMENT