Good morning all, Im not the best with databases but found this app quite nice to use and in all for me to play with maybe moving on to something more challanging..
Currently I have two libraries one named PRF the other OBS,,, essentially the PRF will contain assessment data which is ID with Surname and date of birth, the second library will contain on going observations of the individual declared in the PRF
The relationship is one to many (PRF to OBS)
1. is there a way in the creation of a new record in PRF to generate a unique ID
2. In the OBS library can a field be set to replicate the ID, SURNAME and date of birth, but derived from PRF
Thanks for any help in advance