Recent content by gbeegle

Ted, Thank you very much for your reply. I certainly understand the concept of your answer. However, when you say create a new table to lookup the 3 digits are you saying to create a new table with just state names and area codes?

Struggling to validate a phone number field based upon another field (state). Instructions I am to follow are below. The phone number field includes the area code For a State field value of VA, the first three digits of the Phone field value must equal 703 or 804. If the Phone field value...

Bob, THANK YOU SO MUCH!!! it worked very nicely. Thank you for your expertise and helping me find a solution. I am very grateful.

Bob, Thanks for replying. I am sure I could learn greatly from your St. Vincent example. I understand what you mean by an update query working. Am I wrong in thinking that if I used an "after update" event on the discount rate field (which is located outside the line items area) where it would...

Thank you greatly for replying, The discount is located in the Customer Table. For each customer has different discount rates. The discount is referenced in the line items because they want to show that for each item. My goal is that when someone should open up an existing order to change the...

Have a form that is basically an order form for candy. When a candy is selected it will post it with price and then a new row is automatically added for another selection if needed. And does this each time a candy is added to the order. Customer discounts are calculated in each line item of the...