Unanswered: do i have this right??
This is obviously a newbie question, but where else to ask? I'm putting together a simple inventory and point-of-sale system in access 2002. I have created a form Orders with 2 subforms in it, Order Details and Order Payments. I want to make sure that when selecting a product in Order Details ( through a combo box that displays the products name ) that the rest of the info of the product appears ( unit price, short desc, productid...)
I'm thinking that having Referential Integrity checked and Cascade Update checked also would do the trick. Any other ways to do this?
Thanks a lot!
There are 10 kinds of people, ones that understand digital, others that dont