i want to insert invoice values into databade invoice amount limit and split into multiple row if amount is grater than limit and insert it indicia or group

Re: i want to insert invoice values into databade invoice amount limit and spli 80 80

What have you tried so far?

Re: i want to insert invoice values into databade invoice amount limit and spli 80 80

Because you are not giving a lot of information, I cannot provide a specific solution.
Try to use a case when inserting or a trigger or use a stored procedure that handles this to insert .
Alternatively post your insert code, the db type and what is the program that will do the insert and we can probably help you to figure this out.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of 1.19 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.