gulam
Posts: 55
|
Posted: 09/14/2011, 8:58 AM |
|
Hi,
I am trying to develop a record form where the user can only enter a max of 4 records, after which it should tell him you "have already registered the maximum 4 ............". How can I achieve this?
Thanks
Gulam
|
|
|
datadoit
|
Posted: 09/14/2011, 10:40 AM |
|
When designing the data structure of an application, it's a good idea to
always include these four fields at the end of the DTD:
entered_by (INT, 11)
entered_date (DATETIME)
updated_by (INT, 11)
updated_date (DATETIME)
Then on your record forms include these four hidden fields and assign
them default values accordingly.
From the schema above, you can accomplish what you need simply by
looking up the count of the 'entered_by' field above for the particular
user.
|
|
|
ckroon
Posts: 869
|
Posted: 09/14/2011, 2:12 PM |
|
Data is right.
Put the Add Button in a Panel
On the Before Show Event of the Panel-> Get a count of records input by the user...then Hide/Show accordingly.
_________________
Walter Kempees...you are dearly missed. |
|
|
gulam
Posts: 55
|
Posted: 09/15/2011, 6:44 AM |
|
Thanks for your reply.
I have included the mentioned fields in my schema. I just wanted a little more details on how to do the count.
Thanks
Gulam
|
|
|
mamboBROWN
Posts: 1713
|
Posted: 09/20/2011, 8:19 PM |
|
gulam,
If your question was answered can you please put [RESOLVED] or [SOLVED] in the thread header. Thanks
|
|
|
|