Radio Button.

Set 'Edit as' type of this field to Radio-button.

Set 'Edit as' type of this field to Radio-button.

I believe I tried to do that, but being new at this product I may not have. I'll post the results.
Thanks.

Set 'Edit as' type of this field to Radio-button.

Hi again admin. Sorry to be a pain, but I thought I had tried that and here are the results:
Add/Edit Screens (RB=Radio Button and they would be side by side):
RB-a:

[indent]Apple

Orange

Banana etc[/indent]

RB-b:[indent]Grapefruit,

Cherry,

Grapes etc[/indent]

So what happens is that all of the data from column a in the table are being displayed as radio buttons for RB-a as are the data from column b.
What I need to do is to display and subsequently select from exactly 1 pair: for example:
RB-a: Apple, RB-b: Grapefruit. Clicking on Apple, deselects Grapfruitand vice versa.
On the Add/Edit screen there would ever only be one pair, not all the records.
Much like the Emoticons at the bottom of this page (Post Icons). If you select Emoticon 1 from Row 1, the others are deselected. In my case I only have two choices as apposed to 7.
I hope this helps and any further assistance is greatly appreciated.

Not sure why you need two database fields to store your choice if Apple is always paired with Grapefruit.
I would use a single database field that stores Apple-Grapefruit combination.
There are other ways to implement what you looking for however this is the easiest one.

Not sure why you need two database fields to store your choice if Apple is always paired with Grapefruit.

I think I see what you're getting at. I've thought about this, however, if I store them as pairs (which I think makes sense), then how does one use them in a radio button so that when I click ont he "Pair" I get only one choice?
Or I guess perhaps the question is, how does one use the pair to popuplate a pair of radio buttons?
Thanks again.

I would suggest to post your application to Demo Account and send the URL to support@xlinesoft.com.
This way I can see what your application and provide a better advice.

I would suggest to post your application to Demo Account and send the URL to support@xlinesoft.com.

I can certainly do that, however I'm using MS SQL 2K5, is that going to be a problem? Or I can send a link to the site and provide an eval account.
I'll post to demo, once you've advised the best way to go.
Thanks again, the assistance in this forum is quite excellent.

I would suggest to post your application to Demo Account and send the URL to support@xlinesoft.com.

Hey admin, I figured out how to do this. Took a little coding, but all is well.
Essentially, I created a link on the ASPrunner page to open a page that uses arrays, then updates the table directly. I don't think there should be any issue/conflict with code generated by ASPrunner. It's not exactly what I wanted cause I wanted to do it all in ASPrunner, but it works like a hot damn.
The only thing that I may have to do is to get ASPrunner to refresh the list page when I return, but I don't know how to do this - so I guess more playing is in the cards.
If you can think of anything that may be an issue, please let me know.
Again, thanks for the help, your pointer about pairs sent me in th eright direction.
Cheers <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=32835&image=1&table=forumreplies' class='bbc_emoticon' alt=';)' />