Below is some SQL that I created and modified from a standard .QBE query by using the "View", "Show SQL" commands from the query window.
SELECT d.Child_ID, D1."Date", d2.Goal_ID, d2."Hour", d2.Score, d."Last_Name"+", "+d."First_Name"+" - "+d.Child_ID as SName
FROM "Children.db" d, "Goals.DB"...
I have managed to create some VERY good systems in Paradox with the exception of reports whose filters change from month to month.
1. Report objects run fine as long as filters do not change from month to month and are stored with the report file.
2. As soon as the user has to open the report...
Has anyone ever experimented with TWO updateable tables on one form?
1. Basically I start out with a primary table listing clients I work with.
2. Then I linked it (one-to-many) to a table of medications prescribed for each client:
Clients.DB <-------------->> Medications.DB
One client is...
Through years of experience I’ve noticed that what displays on the screen is not always what Paradox prints. There’s simply too many things that vary from PC workstation to printer in every office. Here’s some things I’ve tried.
1. If you encounter page-breaking problems when printing reports...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.