Recent content by dobseh

That does the job perfectly, thank you kindly!

I've got a form that is essentially a switchboard with a series of buttons that are a user journey through a process. Each button opens another form or report, some of these forms are a popup, others are a fullpage form, one button can return just a msgbox message if certain criteria are met...

It doesn't matter which for the purposes of this. It's just for testing a process without running the entire thing over many, many records and then having to manually check each combination got spat out as it should. Nobody else gets the pleasure of seeing the data apart from me, it's not an end...

Why did my brain fail to realise the obvious answer?! Thank you.

I have a table with some data that looks like the below screenshot. I'm trying to work out a way of returning one s_id for each unique combination of discount_lookup, abilitiy_level_lookup, payment_installments and weekly_sessions. I've put red dots next to the s_id's that the query should...

We tried this, parents only paid one invoice because they thought the other was a duplicate. This doubled the workload of the club co-ordinator and made lots of people very unhappy. What's that saying about "if you design something to be idiot proof, the universe will design a better idiot"...

I fully agree that this is the best approach, and it's the one I have taken in the invoices/orders of physical items section of the DB(I forgot to include the payments table for this in the schema screenshot). The reason I can't take it for this piece is the need to be able to refund individual...

Sorry, but we are going to differ here. This isn't taking automatic payments, there is always going to be user input to enter amounts that have been paid. The money in the bank doesn't go anywhere and is always there as a transactional record of payments that exists in a fully auditable form...

Hah, I worked in PCI compliant companies and been part of a PCI audit - this ain't that, not by a very long stretch. There's no need at all for an audit trail or anything even close, although I fully appreciate that best practice should be to do it that way anyway. This is a very small club...

I think you are saying the process I posted originally with this? Payments entered get validated to ensure that amount_paid is not greater than the amount_oustanding Happy to post the schema, but could you explain what the value of the child table is? I'm not sure why it would be needed, I...

No, the fees go into the feespayable in descending order of price, so that ordering by the ID always gives you the most expensive first. Also end users can't allocate a payment to an individual fee, the form for adding payments just allows them to enter an amount and the database is expected to...

There is an indexed ID field in tblfeespayable that links the child to their fee for that term. This field is written into tblpaymentsmade when a payment is made.

There is a payments table. Your solution is fine but it's really just moving the problem from when the data is written to the table to when it's read. I'd still need to have make sure that if they need to refund then the amount paid for that child is pro-rated rather than just the total amount...

It would be much easier if I could do it like this, but the club has a policy where if a child is leaves then they get a pro-rata refund based on what they have paid and the number of weeks into the term. This means the per child payments need to be tracked so the correct refund can be given...

I've got what I think is a fairly standard order/invoice system in db I look after for a children's club. This club has a term based fee for membership, and each term an order is generated for each parent containing the fee for each of the children they have attending. In the db this populates a...