My question is can a table have two foreign keys simultaneously?
Yes. You can find an example in the manual.
thank you.
My pleasure. And welcome to the SP forums