I have a database with the following:
L-Name, F-Name, MI, Suffix, FMP, L-4 and DoB. The first column has the prime key (auto Number).
The data is related to a patient as they come in for an appointment. Each patient has to complete an insurance form before they can be seen. To keep the patient from having to complete the form each and every time they are seen they will be given a card stating that they have completed the insurance form and do not need to complete it until the end of the current year (or the year that they complete the form).
EXAMPLE:
L-Name, F-Name, MI, Suffix, FMP, L-4 DoB
Duck Donald D. 20 1111 2 Jun 1924
Duck Donald D. Jr 01 1111 2 Jun 1954
Duck Donald D. III 02 1111 2 Jun 1956
Duck Dazy D. 30 1111 2 Jun 1926
This represents the Duck family. Where all members of the same family have the same L-Name and L-4 (or could have a different last name based on a second marriage) other information i.e. Suffix (there can only be 1 Sr., Jr. II and so on)and FMP (there can only be 1 10 -19,20, 30-9, 40-49) are different. How do I prevent dupes from occurring?
I have tried the book way of not allowing dupes and that didn’t work. Does anyone have a workable theory? Thanks Jon