Recent content by Mark_

Buying a cat is pointless. The Cat Distribution System exists because CATS are the ones who decide with whom they wish to live. Paying money is a total waste. Also explains a lack of bonding. 😁

You may want to show this thread as "Solved". If not, we'll see post 115 far to quickly. :)

The times I've had to deal with "Keep the list you are working on", I do so by having a local table in the front end that holds the IDs of the records they need to work with. Then the query runs on this table and grabs the matching records to show. Other option for assigned records uses the same...

Something you may want to do to keep your hair in place. For the values you use in FilePath, CategoryID, and the year you pull from your CkDate, I'd put them into a field on a form you can edit OR store them in a table. This is to prevent you needing to go back in to code some time in the...

Yes. More importantly you can assign specific templates for specific needs so you DON'T have to use a giant template. Think of it more as "I get to turn on and off specific functions on a per control basis".

Fundamental differences between storing code to control behavior for a field in a table and how Clarion does it with templates are 1) Clarion is a compiled language. Updating the template and recompile to achieve updates rather than update code in a table. Benefit is you get the speed of it...

Just to save you a LOT of trouble in the future, I'd replace "Paid" with having a Date Paid in your invoice field. It will save hours the first time you get that abominable entitled client who wants to argue they are always up to date on their account as the invoice shows "Paid" but doesn't...

I would suggest looking at the Clarion programming language to see if their templated application development is what you are looking for.

Depending on what fields are prompted, I can see a separate form that is used with cash purchases to avoid prompting for payment method. This is especially true when you don't want an employee to "Accidentally" print out the "Paid in cash" receipt for a CC or invoice purchase. May even require...

Looks like you want the TOP value SELECT TOP 1 entry_date, entry_amount_kg FROM Tbl_Daily_Entry ORDER BY Tbl_Daily_Entry.entry_date Alternate you could use MAX which implicitly only returns the greatest (TOP) value. In SQL, MIN and MAX are often used, but TOP with either asc or desc on the sort...

As you are looking to treat updating the parent and child/children as an SQL transaction, you can either save the original state(s) of all values so it can be rolled back OR (if you really want to spend some time on this) you could create an array for each field to allow you to store its values...

@BlueSpruce What is the business driver for employees to enter these contracts? Is this something that management can control with proper rules? I am guessing someone is doing this to pad their pay. If this is true, proper response from management should be termination of the employee for...

@mfk5331 I would make sure exactly how they want to track statistics for KPIs. Normally instead of saving a "Shift" in your values, you can either store each value with the date/time it was entered (say amount of a sale) or a date/time for each shift start so you can track statistics from one...

@OP, A couple questions that may dictate your approach. 1) Do you need to associate physical items (inventory, vehicles, what not) to a given transaction? If yes, you'll need to work out assignment and roll back if the customer doesn't go forward with the transaction. This pretty much requires...

For normalization, instead of saving "SUPERVISORCODE_I", you would normally save the AutoNumber ID for the record.