I have a table of users:
Users are allowed to sell things to each other.
I need a table to record sales data between users.
buyerFK foreign key to USERS.id
sellerFK foreign key to USERS.id
problem is that my database which is SQL Server express does not allow me to have two foreign keys pointing to the same table (USERS).
How can I solve this problem please?