Exactly what relationship links Donors and Tickets?
If you have this relationship:
Donors::DonorID = Tickets::DonorID
You can add any fields you want from Donors to yoru Tickets layout. When you select/enter a DonorID in the DonorID field, the fields from the dontor table will then display data from that donor's record in the donor's table.
I do have the Donors:Donor_ID = Tickets::Donor_ID, but for some reason whether I insert fields in the tickets layout linking back to the donor table or inserting fields that look up the corresponding value in the donor table, but if I insert the Donor_ID or the Org/Company the other linked fields don't fill in. Not sure what I'm doing wrong.
Thanks, it worked I set them as look ups and it worked when I entered the donor id. Ideally I'd like to be able to select either the donor name or organization and have it complete the rest of the donor info. Somehow I got it work in a fee for service database I did a couple of months ago, but I can't get it work.
What you describe is possible, but requires scripting.
Here's a demo file that illustrates several scripted methods that use text entered by the user to find a records ID number and then enter it in the appropriate field to reveal the related info: