I have table with composite foreign key (consists of two attributes) (stupid, byt not my work)
When i edit data in table, i want to have possibility to use helper which shows possible values from master table. It works for single attribute key, but not for double.
Maybe i am stupid, but i think that it worked yesterday and is not working today.
Maybe some change in structure? Or what? Foregin key is ok, because it refuses commit when i enter nonexisting key.
THNX
Table(MS SQL):
CREATE TABLE [dbo].[ECON$TestProductsTR](
[Brand Code] [varchar](10) NOT NULL,
[Line No_] [int] NOT NULL,
[LNGCode] [varchar](10) NOT NULL,
[DescriptionLNG] [varchar](120) NULL,
[SalesLNG] [varchar](120) NULL,
CONSTRAINT [ECON&TestProductsTR$0] PRIMARY KEY CLUSTERED
(
[Brand Code] ASC,
[Line No_] ASC,
[LNGCode] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
ALTER TABLE [dbo].[ECON$TestProductsTR] WITH CHECK ADD CONSTRAINT [FK_ECON$TestProductsTR_LNG] FOREIGN KEY([LNGCode])
REFERENCES [dbo].[ECON-TR$Languages] ([LNGCode])
GO
ALTER TABLE [dbo].[ECON$TestProductsTR] CHECK CONSTRAINT [FK_ECON$TestProductsTR_LNG]
GO
ALTER TABLE [dbo].[ECON$TestProductsTR] WITH CHECK ADD CONSTRAINT [FK_ECON$TestProductsTR_TestProducts] FOREIGN KEY([Brand Code], [Line No_])
REFERENCES [dbo].[ECON$TestProducts] ([Brand Code], [Line No_])
GO
ALTER TABLE [dbo].[ECON$TestProductsTR] CHECK CONSTRAINT [FK_ECON$TestProductsTR_TestProducts]
What is the condition for activating foreigh key lookup? Because my foreign key works, but editor does not show lookup values.
table2 (secondary): foreignKey = town, street. other fields: LNG,Description .....
in field TOWN i want to have possibility to choose from all possible values of TOWN from table1.town.(only this one field)
It works when i have simple key, but dont works when i have composite key.
I think that day before it worked. Maybe i changed something in FK declaration or so...
It would be great if it can choose both parts of compound key by one selection.
Thank you for your feedback. We've added this improvement to our to-do list.