Autofilling fields based on "if" "then" scenarios
Hi, I am creating a relational database linking donors and missionaries to their donations. I am attempting to have information from the donor and missionary tables auto-fill in the same named donations table. For example, donor ID #3 is for John Smith under Donor table. Missionary ID #JD1 is for Jane Doe under Missionary table. When John Smith donates to Jane Doe, I want the donation table to auto-fill the 2 ID #s that link the donor and missionary based on their names.
Is this possible? Thanks!