Laurie,

Do you want each database to be entirely independent from each other? (you remove the inactive customers from one and put them in the other totally stand alone)  or active and inactive to be part of the same application but 2 separate databases?  (you open up 1 app with 2 separate databases one holding active the other holding inactive)

May I be so bold as to ask why you want to remove the records rather than just code the active verses inactive within the same database so you could then run history reports and mailing lists etc.

Sesame handles huge amounts of data without any hiccups, so if fear of speed or problems with large amounts of data is your concern, they may be unfounded.

Let us know what you want to accomplish and we will try and point you in the proper direction to achieve your desires.

Laurie,

It sounds like you are looking to create a fairly basic application that with Sesame is a breeze to create.

First have you looked at the Sesame sample applications? you may want to look those over and see what features you like. You could even use one of them to work from.

Now about your application, If I understand correctly you enter accounts that have your honor vending machines at their premises.
You will have an element (maybe a checkbox) that Identifies active or inactive
you will have elements that puts the date and time the account was entered into the system when it is created
you will have a unique ID that the system will create for the account the first time it was created.
I imagine you have all the basic demographics, Name, contacts, address etc.

With the above elements you can easily have buttons that you push that shows you:
active with a total count of how many.
not active with a total count of how many.
records entered today with a total count of how many.
records entered for week or month  with a total count of how many.
you can also have how many inactive based on the same info as above.

You could then have a subform that keeps track of each time you go out to a specific location
so you would have a single record for the account, but would have unlimited records of each time you go to a location.

Do you keep track of what was sold by each machine? you could have a separate subform that tracks itiems that was sold at each location.

Am I close to understanding what you would like to do? What I have described is a breeze to accomplish in Sesame and you could do this in a few hours and you would get lots of help from us all on the forum.
If you need a little help I  would be glad to create the rough application for you to get you started and then email it to you so you can build on it however you desire from there. We all needed help at the begining! The people on this forum helped me every day for a long time.

What I found when I switched from Q&A to Sesame is the things I only dreamed of doing with Q&A was only the starting point with the power and simplicity of creating with Sesame.

Your second question about deleting could be one of 2 things. if you want to delete a database from an existing application you can use the Trim application. Search the user guide for trim (in mine its at page 429 but I am not sure if my manual is as new as yours)

Now my interpretation of what you are trying to delete is the layout form and that is done by opening your application in Sdesigner and selecting Manage a database from the main tree, then select manage layouts, then goto action tab and select delete a layout then layout name, then click form then select form name you desire. Next you click the button labeled add transactions to batch then click run batch button. That's it...

bob

i have already translated over the account database and have all of my active accounts in it.  the applicatin is called munchbox and the form is called munchbox i want to use same layout for another form called nonactive.  thought i might explain myself a little better as to what i want.  

in q and q what i had done was copy the active database and named it nonactive then as i said copied the records.

and yes i have name address city phone contact name date we got account and active elements in layout.  if you would like i could send you the app with the one form in it then you would see what i need done for the second form.

thank you the delete form/databse worked.

laurie wrote on Mar 3^rd, 2011 at 1:03am:


Laurie,

Check your private messages.

Laurie,

You are very welcome, I am glad I could help.

Keep us posted on how your project is going. If you get stuck on anything give us a shout.