Going along with the datagrid from my last question - I noticed I couldn't edit the table and remembered it's because I didn't have any primary key - so I edited the table and added the correct composite primary key which consists of three fields and I redid the Infer Database in hopes of updating it... but now that table never even gets picked up - it's as if it's not there and it's not among my Schema options.
Is there any way to scaffold the table with a composite primary key?
Table Structure:
CREATE TABLE [dbo].[NewAttachments](
[CorpID] [int] NOT NULL,
[PatientKey] [int] NOT NULL,
[AttachmentSeq] [int] NOT NULL,
[ClincKey] [smallint] NOT NULL,
[AttachmentAccount] varchar NULL,
[AttachmentPatient] varchar NOT NULL,
[AttachmentType] varchar NOT NULL,
[AttachmentDate] [datetime] NULL,
[AttachmentPath] varchar NULL,
[AttachmentName] varchar NOT NULL,
[AttachmentChangedBy] varchar NULL,
[AttachmentAcknowledged] datetime2 NULL,
[AttachmentAcknowledgedBy] nchar NULL,
CONSTRAINT [PK_NewAttachments] PRIMARY KEY CLUSTERED
(
[CorpID] ASC,
[PatientKey] ASC,
[AttachmentSeq] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
