Auto Enter Calculation pulling from 2 fields
I have 3 different databases (roll, sheet, invoice) and i'm wanting to put a field in one that pulls from the other 2.
So, say i have my database for roll items and one for sheet items. In the invoices databse i want to have one field called puchase order and have it be an auto enter for whichever PO (either roll or sheet) that has a value.
I just dont want to have to have 2 fields in invoices (one for roll PO and one for sheet PO). I just want to have one.
Is this do-able?