If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

Unanswered: do i have this right??

Hi,

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!

Cheers!

Mr.Crud

There are 10 kinds of people, ones that understand digital, others that dont