Better auto id

Had issues with joins using default id= 'id' so default will now use table.id and if a join is found (regexp on a period) the field will be extracted (after the period) to be used in the first and last item functions.