Recent content by pixiedust

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...

Thank you for the information, this is just a little task I have been set. I will make amendments to the names so they follow a better standard. The SQL shows up like SELECT Customer.[Customer ID], Customer.[Company name], Customer.[Address line 1], Order.[Order ID], Order.[Date of order]...

Hi, I have attached the relationships between my tables. I am not allowed to use an invoice table for this so it needs to be done through a query. Not to sure how to show the SQL code as I have done it through the query builder. Thanks

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...

I know its not really a forum, but I find Stack Overflow very useful when I need guidance on AngularJS. If you wanted more of a forum, try DreamInCode. Its not a forum specifically for Angular, but many members on there can help you with anything.

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.