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!