Okey pros i have a small question.assume that below sinario where i have a Two tables called Organizatioin and Organization_Members (One organization can have many members 1 to Meny)
Organization_ID - PK
Member_ID - PK
Organization_ID - FK
I recently developed a system for this type of senario where i get both details from the user in same page (easyer to use) in the same form i get organization details and in the same form i get who are the members in this organization (accoding to customer request).
My programming logic is first i got the Next increment value of Organizatioin table from the SQL database and stored it in a variable
afterward i did simple insert statement for organization table. for organization_memebers table i insert with user input data along with my next increment variable ( organization attached to member) it just worked fine
. i want to know is there any easy / genuine way to preform the same task in my future projects ? thank ou