Hi, sorry for such delay!
I attached my view of how i see and made my database. in simple way.
i hope it makes more sense to what i have created.
i have made other version, where i added field in each table - client, visits, medication, vacination. made log_on table where it takes tempvars and...