Hi Dear All,

We have three tables, Unit, Asset & LoanAsset. Unit_id & Asset_Id coming as FK and we have to insert into LoanAsset table with generate LS_Id. Look into the below records, "How can we achieve this style of ID generation"????

I will be much thankful to you for cooperation....

Primary Key = Unit_Id(fk) + Asset_Id(fk) + LS_Id

Unit_Id(fk) Asset_Id(fk) LS_Id
1 89 1
1 89 2
1 89 3

1 120 1
1 120 2

1 115 1
1 115 2
1 115 3
1 115 4