Search results

Thanks for your response. I am not actually changing or adding the record. I know I didn't explain what I am doing but here goes. I am trying to setup a database that keeps track of my wifes transactions. I have been searching this forum and others to try to get the concept of how to do this. I...

I am getting a "cannot change or add a record because a related record is required in table 'tblOrder'". I have scoured this site so forgive me if there is a post already on this. My Order table has: OrderID CustomerID SalesTaxRate My Order detail table has: OrderDetailID PoNumber TransDate...

John, I know you never can hear this enough, but you are awesome! I believe this is exactly what I wanted. I will look at how you set that up so that I can learn how to do it on my own. Just so you have an idea of why I am doing this, it's actually for my wife. She started to sell Mary Kay...

John, this sorta explains it. The sorta is only bc of my my lack of knowledge with access. The reason I had customer.* in the first column in the query was bc I was following what the template was doing. I did change it that before but it didn't seem to matter. Anyways, I do have another issue...

ansentry, you are awesome! I am pretty sure that is what I needed to do. You even solved my subtotal and totals problem which would have been my next question. I guess the next question would be is what did you do to get al that to work. Like I said, I tried to follow the templates that MS...

Hey guys, I have a question that I am hoping you can point me in the right direction on. Before I ask it, I am new to access. I have been looking at templates and reading and things on how to build a database. I have my tables setup, relationships I think are right and my form created. One of...