Table relation

awatharam86awatharam86 Member Posts: 49
Hi Friends,
How if we want to create a new table which primary key same as other table. for example my new table, should show primary key field same as Item table. So whenever Im running my new table, it should show primary key field same as item table automatically. And other records value will get from flowfield from other table basic from primary key value.
Please Help.
Thanks in advance.

Comments

  • einsTeIn.NETeinsTeIn.NET Member Posts: 1,050
    You need to create the records in your new table based on the OnInsert triggger of the item table. You can't use a flowfield as primary key.
    "Money is likewise the greatest chance and the greatest scourge of mankind."
  • awatharam86awatharam86 Member Posts: 49
    ok gotcha.... thank u friend.
Sign In or Register to comment.