🚀 go-pugleaf

Hi to all,
im new to MsAccess,im using a relational database called Alpha Four
for dos.
I made an application in dos and i would like to make a new one with Access
and ,so far everything is quite good but.......but i have a problem in wich
im stuck since almost a month.

I created 3 tables :
Invoice:     Index-InvoiceNr.--Date--TableNr-Status
Details:    SaleCode--ProdCod--Qty--SubTotal
Products: ProdCod--Description-Price

So i made a relation beetwen them and i made a form to introduce
all data for the tables (restaurant businness)
I dont want to keep all the data for every day because after 2 or 3 weeks
i will have a big file and a kind of slowliness so  i want to be able
to keep all the "today" data in a safe place in the hard disk wich i cant
change from the main application but i do can change in the safe copy file.

If its necessary for you to help me ,i can send the application so maybe
you can work direct in to it.

Thank you very much for your time and i hope that  someone will answer me
soon direct to my email address.

Best regards from Claudio

claudio_v_@hotmail.com