How can a primary key be inserted as foreign key?
If you insert multiple Order records (pick a new name that's not a keyword, by the way) then you need to use the OUTPUT clause.  Otherwise SCOPE_IDENTITY() should work.

Quick example using SCOPE_IDENTITY:

DECLARE @OrderID int

INSERT INTO
  Orders
   (&lt;columns&gt;
VALUES
 (....)

SET @OrderID = SCOPE_IDENTITY()

INSERT INTO
  Properties
   (OrderID, ...)
VALUES
  (@OrderID, ...)