Search results

Hi, I have a Select query I use to generate a report. Query is simple enough, it checks to see if the field Invoice_dispatched is false. So this works fine, and produces the report fine. However, whenever this query is run, I need it to then update the Invoice_dispatched field to true. So...

Hi, I have what is probably a familiar set up. I have the following tables Product OrderLine Orders Customer I cant post an image of the relationships at the moment due to my post count, but a Product can have one to many Orderlines. An Orderline can have many to one Orders. And Orders can...

Hi, I am pixiedust, just wanted to introduce myself to the forum. My main reason for coming here is to learn more and to hopefully contribute in the future.