Dear Steve,
Thanks for the reply. I have a form where the user can change the Default Store. Thus I want a way where I can change the Default from the form.
Thanks,
~R
Hi Guys,
I have a table with the following fields:
StoreID (PK)
StoreName (Text)
Address (Text)
Default (?????)
I want to create the table with a list of stores where only 1 store can be a 'Default' store.
Is there any way that I can force this in the table design (like a radio button...
Dear lagbolt,
Thanks a lot for the help. I tried this way of doing it but did not get the whole way through. I think I am missing a little insight because of which I am unable to replicate the my case. Details:
I have three tables:
tParent1
Parent1_ID1 (PK - string)
Parent1_ID2 (PK - string)...
Hi,
Can someone please help me to establish one-to-many relationship with cascade update and cascade delete feature. I know how to do this in the table relationship window but am not sure how to get this in VB.
Thanks,
~R