i have a two table one is sale which has a one primary key sale_id and second table which name is saleDetails which has one primary key sale_detail_id and second is sale_id as a foreign key these both make the Composite key my question is that sale_detail_id is auto increment so what i can do with the sale_id