Limiting records in a table?
Quote:
> How do I limit the number of records in a table? Say I have a table called
> "Timekeepers". I only want the user to be able to key in a maximum of 3
> Timekeepers, how do I do this?
> I see the problem if a timekeeper leaves, but how dow you limit the number
> of records? Needless to say, if you loose a timekeeper, it would be easy to
> change their code to a new one and let it SEEK and REPLACE from the old to a
> new one.
> Very truly yours,
> Jonathan Morningstar
> Morningstar Technology Corp.
> Greenville South Carolina USA
Supply the table with three records with the app and do not include the
ability to append new records.
Another method would be to check the number of records before appending a new
record.
IF RECCOUNT()< 3
INSERT INTO
ELSE
WAIT WINDOW "The permitted number of record alreay exits"
ENDIF