topic Table creation in Application Development and Automation Discussions

Table creation

Former Member — Sat, 23 Feb 2008 06:13:29 GMT

Hello gurus ,

I have to design a ztable for FICO (collection entry) , in tht I have insert multiple invoice no that may be non unique against invoice no I have to insert mjultiple chk no chk amount bank key and many more , but the prob is that I have created the Ztable , in that I m not able to insert non unique invoice no , becz that one is primary key . I cant delete the primary key becz in a table atleast one primary key req . I have to create such kind of ztable where multiple duplicate entry possible in every field , hw it is possible ?

Is there any option plz help .I m waiting .

Thanks in advance .

Joy

Re: Table creation

Former Member — Sun, 24 Feb 2008 07:14:48 GMT

how r u trying to do the insert?within the program or transaction.

primary key is the basic of RDBMS.

u can have account no. as primary key and u can hv multiple entries,invoices for each account.

Hope this helps.

All the best.

Re: Table creation

Former Member — Mon, 25 Feb 2008 03:53:31 GMT

Hello friend ,

Thanks for rply . In my table , account no can be unique but as per client req , invoice no can be duplicate for per account no , and they want to insert multiple invoice no againt account no . Thats why I have generate auto no inside the table , when they press the save button in appilication toolbar , a auto no will generate and taht one is unique and my prob is solved .

Thanks sona 4 rply and ur valuable time .