General information
Category:
Coding, syntax & commands
guys,
I am building a risk management system
I have a one code table for my customers where they can put
specific codes in , the table structure looks like this
icode , ccodenumber , ccodename
i am having a problem to get the primary key right.
my primary key is on icode and ccodenumber .
usually i have more codetables for my customers and then i put
a program in each table that generates primary keys.
I put this program in the default value of the field that is the
primary key and i give some parameters to it like this
do generatepk with "tablename" etc etsc,with one code table i have a combined primary key on icode + ccodenumber .I want to have the same idea as i used to with several tables(have a program in my default value) but i need more flexibily off determing which icode it is
etc etc
thanks
david
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only