Requireed value to pop up a new form

[Guest]

Hello im stuck.
I am trying to simplify a project management database.
I have bound clients to Projects and when i open a new project i want to be
able to enter a new number (1 - 1000) should open a new table(premade called
Financials) 1001-2000 should open a second premade and 2001-3000 should open
a third. How do i set this up???
I can be reached on msn.
(e-mail address removed)
Thanks in advanxce

 

[Guest]

Rather than simplifying it, you are making it more complex and violating good
database design rules.
If the data needs to be separated by those values (1 - 1000), (1001 - 2000),
(2001 - 3000), etc. then rather than several tables you need only one table
with a field that identifies to which group the record belongs. Then when
you need to look at a particular group of data, use a query filtered on that
group rather than the table itself.

 

[Guest]

So how do you suggest i do this??
Is there any way i can send you my data base so u can see what i try to do?
Thanks

 

[Guest]

If all your tables have the same structure, the method outlined in my
previous post will work). If the tables have different structures, then you
should have a different form for each type of table you have. Then when you
open a new project and enter a number, you could use a Select Case statement
to determine which form you want to open.

I would not mind looking at your database; however, I am in a secure
location and can't import it or receive it in a E-mail.

 

[Guest]

Ok how do you suggest i get the database off to you??
I mean i can technically zip the file, upload it somewhere.. but where?