I'm trying to link my order data to contacts via lookup fields but currently I understand that the only lookup option is using the Contact Name. Since this is not at all unique, I would like to instead use the contact email address. Ex. our order record would contain the contact email address and should lookup to the contact email address field to connect the 2 modules.
How can I do this? Please help!