auto-populate when importing into another table
I'd like to populate a table with client-id's and their last-activity at the moment I import a file called "deliveries" which contains all id's and all their last-activities. (could be thousands of lines).
I know how to use the function "Max" in a calculation to find out which activity is the latest for the client.
What I want to do is: create a table with only unique client-id's (PID) an their latest activity (max).
I appologize for maybe not being totally clear; i am dutch and try to be as precise as i can be.
In the screenshot you see six PID's (Person-id's, client-id's: 164062,164039 etc...) with their activities.
I'd like a tabel that only contains six id's (PID's) and the latest activity.
OOoooorrrr...: how can I import only UNIQUE PID's with it's latest activity into my deliveries-table? (so: don't import if it is not the latest client-activity) WOW, if you could show me that, ...would be the best! tnx