Limiting Entries

[Moridin]

MS Access 2000

How do I limit entries in a certain table to a certain amount, and then when the entries excede the desired amount the goto another table?

 

[Dreamboat]

Before I would even answer that question, I have to warn you that it sounds like very bad database normalization.

What's your purpose for having two tables?
techsupportgirl@home.com

http://www.WeDoManuals.com

Brainbench MVP for Microsoft Word at

http://www.brainbench.com

 

[Moridin]

So i can set up a waiting list...
I want it to kinda be like a waiting list, limited to a certain amount of ppl and the rest be put onto another list.

doesnt necessarily have to be 2 tables i guess...