Single selection field in the table.

[razdanrahul]

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 functionality, where if I select one other are unselected).

Currently I have a 'Check Box' in the 'Default' field and am trying to handle this via VB code.

Thanks.

 

[Steve R.]

The quick answer is that you can use the store number ID (StoreID (PK)) to hard code the default store and then use DAO to go to that record whenever you open a form or report.

 

[razdanrahul]

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