I am trying to automate firing notification for ceramicists when they pay for a firing.
I have a master table with all member information including member id, phone number etc. Primary field is their “first name last name”
when a ceramist pays for a firing through paypal, a 2nd linked table “PAID” is updated with name, date and price from the paypal info. I also update the linked field in this table with their name. My hope was that the lookups fields of member id and cell number would be updatedin the PAID table
??? how can I get the member id and cell number to fill in automatically from the master table ( the lookup fields ) when a record is created in the PAID table using the paypal name in the linked record field ?
I tried updating the linked record in PAID table with the zap paypal name ( hoping the lookups would just happen… ) this is shown the screen capture.
gawd I hope this makes sense