If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Duplicate forms-prevention on use of date of birth+ surname
The reply to my query ( prav_123)is basically the help I need very much: I
don't have a 'student number' in my form field and I tried to substitute Date of birth in the sample code sent.I am a real novice but 'nothing happened! just got duplicate form entries.How do I link the code to my datatable/forms for it to work.There will be a risk of more than one person sharing the same date of birth but this risk is small for my needs.If I could include the individual's surname how do I state both these parameters in the code.Please help/Many thanks |
#2
|
|||
|
|||
Duplicate forms-prevention on use of date of birth+ surname
When you don't have a natural unique identifier, the best option is to use
an autonumber. What would you do if you had two people with the same surname and date of birth? Would you change their surname? Would you change their date of birth? Would you change the application to add a sequence number to the primary key? "prav_123" wrote in message ... The reply to my query ( prav_123)is basically the help I need very much: I don't have a 'student number' in my form field and I tried to substitute Date of birth in the sample code sent.I am a real novice but 'nothing happened! just got duplicate form entries.How do I link the code to my datatable/forms for it to work.There will be a risk of more than one person sharing the same date of birth but this risk is small for my needs.If I could include the individual's surname how do I state both these parameters in the code.Please help/Many thanks |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How do I correct how a birth date shows in a mail merge field? | Grace | Mailmerge | 1 | January 31st, 2006 09:53 PM |
URGENT - access date of birth validation | MINA | General Discussion | 9 | October 28th, 2005 04:30 PM |
Copy Cat Ain't Working | shep | Setting Up & Running Reports | 15 | September 12th, 2005 05:14 PM |
Date Range and Average F/X Rate | David | General Discussion | 0 | June 23rd, 2005 02:26 PM |
Does date fall between two ranges? | MR | Worksheet Functions | 4 | January 14th, 2004 04:08 PM |