[Solved] Radio Buttons in My Form Not Writitng Data to Table

[KeithK]

I am trying to create a database in Base to deal with the membership and mailing list of a non-profit. Its been some time since I have played with Base and I am about to put my head through the monitor. I finally got the DB created, the membership table created, a cell structure that I like in place and after much fighting, finally got a form created that will allow me to add new records.

This non-profit NGO is issues-based has two levels of membership right now. Paid members and unpaid members who are sympathetic to the cause. Paid members get some things that non-paid members don't, like a newsletter because, well, they pay for it. A proposal is on the table right now to go from having just one tier of paid membership to about six.

So I am trying to make a DB that will allow me to implement every possibility and that will support the tiered system of membership regardless of what happens with the proposal (its likely that the board will adopt the proposal). The form sort of works. It does add records, but the radio buttons do not do what I want them to do. Towards the top, there is a radio button on the add new member form to set that member as an "active" (paid) member or not. On the DB side, I tried setting it up as a Boolean field (yes or no) with input required but it would constantly tell me that the field was not filled out if I left the radio button darkened (as I would in the case of adding a non-paid member to the DB). The same is true for the block of opt-in radio buttons regarding SMS messages, e-mail, fax, snail mail, etc.

The org had been using a spreadsheet with all these columns to manage the 180 paid members and 3700 unpaid members, but I do not intend to continue that practice for obvious reasons, far to much of a PITA. But I have spent most of the day on this thing and am getting frustrated. Is there any way to get the database to see an unchecked radio button as a negative response, instead of data that is required but not put in by the end user? I don't want the user to be able to skip making a choice and I want the default to be negative (i.e. unpaid and opted out of all communications unless specifically opted in), can anyone see what I need to do to make this a reality?

Second issue is, how do I define multiple choices in a drop down box instead of a variable text field? For instance, on Membership Level, I want to offer only the options that end up being agreed on, instead of letting folks put in whatever they want. Same with state, country and some of the other stuff.

Third and final question is regarding the three boxes I have at the top for Join Date, Renewal Date and Due Date. How can I make Join Date default to today's date, Renewal Date default to today's date if I select active member (otherwise stay blank) and Due Date default to a date 365 days from the current date if I select active member (otherwise stay blank).

Database (which I think has the form inside of it) are attached below.

Membership.odb

Database + Add Member Form

(13.09 KiB) Downloaded 170 times

Running and loving OOo 2.4.2 on Windows Vista 64-bit.

Thanks in advance for any help anyone comes up with.

[r4zoli]

Use Check box instead of radio button.

[KeithK]

Use Check box instead of radio button.

Damn, that was easy. Duh. Thanks.