CREATE TABLE [BillPayment] (

 [billpaymentId] [int] IDENTITY (1, 1) NOT NULL ,

 [billPaymentDate] [datetime] NULL ,

 [newBillBalance] [float] NULL ,

 [billAmount] [float] NULL ,

 CONSTRAINT [PK_BillPayment] PRIMARY KEY  CLUSTERED

 (

  [billpaymentId]

&nbsp

no idea?

any idea??

1. yes; payCode is for cheque; cash or card payment. how can we make relation with paymentTypes if we remove paymentId from the table?????

2. if i loosely coupled invoices with payment...

Hi,

CREATE TABLE [Payment] (

            [mobileNo] [bigint] NOT NULL ,

            [customerId] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,

            [referenceNo]...

yes; i got it. thanx

i wishhhhhhhhh i can do that 

but problem is when i test in query analyzer; it also says these values must bed entered 

yes; it's a sequential id

in the table both; userId and branchId are Part of PK that's composite key. how can i join on both these keys??

ive tried to get this data through my application also. there is a drop down list which is getting data directly from database and i've to just select it but problem remains...

any idea?

any idea?

plz explain what do you mean by order of insertion?? do u mean order of attributes or order of tables?

if this is order of tables then plz tell me...

no groupId exists in the table "Groups". it already has data inserted in it!!!

thanx;  it works!!!!