creating table relation in msde

Hi,

I have created database with 2 tables in MSDE using Access 2002 as the front end for MSDE. My question is using Access 2002 as front
how do I create relationship between my tables ?

Thanks

It would be better to have the relationships existing in the backend before your created the MSDE

Otherwise create the relationship in your front end the same way that you would have created them in the backend. Click on the relationship button in the standard toolbar and add the two linked tables, and drage and drop a realtionship between them

S-

Thanks for your reply. When you have created database with table in MSDE using Access as front end you do not get the option "relationsship" where you can click. I could not find it, it is disabled. But I know if you have tables in Access then you do get the opton of relationship....