AnsweredAssumed Answered

Autofilling fields based on "if" "then" scenarios

Question asked by JennyFox on Feb 20, 2014
Latest reply on Feb 20, 2014 by philmodjunk


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!