Example use case:
I have three objects: Order, Item, and OrderItem. OrderItem is the junction object that relates Orders to Items (because an Order can have many Items) and Item to Order (because an Item can appear on many Orders).
Now, if I employed CSRs to take customers' orders over the phone, logically they would create a new Order in the system, and add existing Items (filtering by ItemID) to that order. In this case, the OrderItem junctions are created automatically without the user of the system even noticing.
Is this possible in Salesforce? And, can anyone point me in the right direction regarding how to accomplish this?