I have to store information about parents i.e. mother and father, however what do i do to make access happy with just either 1 set of information, i.e. either 1 set of information will be sufficent, but atleast 1 full set is required. THX!!
:mad: I know that there is the auto number function, however i would also like it to generate an ID with charaters. In my table theres a first name and surname.
Say for example: Harry Potter, i'd like the ID to generate HP001
then say there's another guy call Harriet Potter, i'd like the it to...