I am working on a Service call management data base and i cant ge.

[Guest]

i have been working on a service management data base and i can not get it to
open a new invoice it just keeps adding to the one that i already have going
so i can not have more then one invoice with out paying out the one and then
i still cant open a new on one the front screen it just keeps adding them
together
help please totaly helpless

 

[John Vinson]

i have been working on a service management data base and i can not get it to
open a new invoice it just keeps adding to the one that i already have going
so i can not have more then one invoice with out paying out the one and then
i still cant open a new on one the front screen it just keeps adding them
together
help please totaly helpless

Without knowing something about the structure of your tables or your
forms, all I can really say is "you've designed something
incorrectly".

Remember - YOU can see your database. You know what "the front screen"
is. We see what you have typed, nothing more.

Please post a *text description* of the tables in your database and
how they are related, and of the Form which you're presumably using to
add data to these tables. Please do not post or EMail the database
itself without a specific request to do so.


John W. Vinson[MVP]