check this , is there something wrong here , this is the interpretation of what you gave me. Because your request is coming from one table, am not sure what is your problem anymore. You have mentioned a field that does not exists in all these tables "category " , Please clerify
create table TBLSUPPLIER
(
sup_lID int Primary Key Not null ,
sup_sCode varchar(10) Not null,
sup_sSupplierName varchar(100) Not null,
sup_sAddress1 varchar(100)null,
sup_sAddress2 varchar (100) null,
sup_sAddress3 varchar (100)null,
sup_sArea varchar (50)null,
cty_lID int Not null,
sup_sEmail varchar (50) null,
sup_sPincode varchar(10)null,
sup_sPhone varchar (50) null,
sup_sMobile varchar (50) null,
sup_sFax varchar (50) null,
sup_sServiceTax int null,
sup_sPAN varchar(50) null,
sup_sTIN varchar (50) null,
sup_sPrincipalName varchar(100) null,
sup_sDesignation varchar (100) null,
sup_sPaymentTerms varchar (200) null,
sup_sRemarks varchar (250) null
)
CREATE TABLE TBLSUPPLIERITEM
(
sui_lID INT PRIMARY KEY NOT NULL,
sup_lID INT FOREIGN KEY REFERENCES TBLSUPPLIER(sup_lID) NOT NULL ,
prd_lID INT FOREIGN KEY REFERENCES tblProducts(prd_lID) NOT NULL,
sui_dRate INT,
uom_lID INT FOREIGN KEY REFERENCES tblUOM(uom_lID) NOT NULL ,
)
CREATE TABLE TBLPRODUCTS
(
prd_lID int PRIMARY KEY Not null,
prd_sName varchar(50) Not null
)
CREATE TABLE TBLUOM
(
uom_lID int PRIMARY KEY Not null,
uom_sName varchar(25) Not null
)
Thank you for posting at Dotnetfunda
[Administrator]
Anu_dgr8, if this helps please login to Mark As Answer. | Alert Moderator