Hello
I’m building a database for refund request. Each refund can be for a patient or insurance company, but all refunds most be linked to a patient name. I have one table that has all patient information and another table that has all refund orders. On the form I will have a textbox called Payee and patient name. Payee box would be who the refund goes to and the patient name would be which account the payment coming from . Should I build another table for insurance company or should I change patient table to hold both patient and insurance information?
Thank you,