Composite Primary key in Parent Child relationship table.
Hi. I have the following tables
User.Order [Parent][Primary Key : Year , Month, OrderNo]
> User.OrderDetails [Child] [Primary Key : {%%PARENT}("ITM")(Running Number)]
> User.OrderDetails2[Child] [Primary Key : {%%PARENT}("ITM2")(Running Number)]
My question is there any problem if I use a composite key in User.Order? I am using the composite key is because I have a lot of records each month(millions) and sometimes I will need to clear the records for a specific month for reloading, with those primary key removing the data would be easier (possibility faster too).
Currently I am aware that I cannot use "||" in my Year/Month/OrderNo, not an issue. Is there any other problem? Worried I might not able to pull out the records from the data after I implement the table design.
Thank you.
Regards
Jimmy