Hello,
i need you to help me with something...i am trying to auto fill some fields of a detail table with values of another detail table ...i need to filter with a field in the first master table...for example...
i need to select ResultadEstudios.NroItem and fill fields "grupo, detalle, unidades, valoresDeReferencia" with of ResultadosEstudios table with "grupo, detalle, unidades, valoresDeReferencia" from DetallesTipoEstudios considering DetallesTipoEstudios.IdTipoEstudio is the same as EstudiosPacientes.IdTipoEstudio because is the master table.
How can i do that?
tables:
USE [EstudiosBioquimicos]
CREATE TABLE [dbo].[DetallesTipoEstudios](
[IdTipoEstudio] [numeric](4, 0) NOT NULL,
[NroItem] [numeric](2, 0) NOT NULL,
[grupo] varchar NOT NULL,
[Detalle] varchar NOT NULL,
[Unidades] varchar NULL,
[ValoresDeReferencia] varchar NULL,
CONSTRAINT [PK_DetallesTipoEstudios] PRIMARY KEY CLUSTERED
(
[IdTipoEstudio] ASC,
[NroItem] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
CREATE TABLE [dbo].[EstudiosPacientes](
[IdEstudio] [numeric](8, 0) IDENTITY(1,1) NOT NULL,
[Fecha] [date] NOT NULL,
[IdTipoEstudio] [numeric](4, 0) NOT NULL,
[IdPaciente] [numeric](6, 0) NOT NULL,
[IdBioquimico] [numeric](6, 0) NOT NULL,
[Finalizado] [date] NULL,
[Obervaciones] [text] NULL,
CONSTRAINT [PK_EstudiosPacientes] PRIMARY KEY CLUSTERED
(
[IdEstudio] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
CREATE TABLE [dbo].[ResultadosEstudios](
[IdEstudio] [numeric](8, 0) NOT NULL,
[NroItem] [numeric](2, 0) NOT NULL,
[Grupo] varchar NULL,
[Detalle] varchar NOT NULL,
[Resultado] varchar NOT NULL,
[Unidades] varchar NULL,
[ValoresDeReferencia] varchar NULL,
[Imagen] [image] NULL,
[Obervaciones] varchar NULL,
CONSTRAINT [PK_ResultadosEstudios] PRIMARY KEY CLUSTERED
(
[IdEstudio] ASC,
[NroItem] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]