anyone ever work with File Maker Pro? DB Software like Access that originally came out for the Mac but now is available for the PC...
anyways, I have 5 radio buttons in a value list associated with a field called "Department Name" I'd like a department number to appear in a "dept num" field based on the dept name radio button the user selects.
the following code in File Maker does this: (case statement)
Case(Department Name = "Administration",615001, Department Name = "Faculty Accounts",615002, Department Name = "Undergraduate",615003, Department Name = "Graduate/Post Doc", 615004, Department Name = "Core Facilities/Services",615005)
However my problem lies in the fact that when a radio button is clicked and the department number then appears in the dept num field, if the user then decides to click a DIFFERENT radio button, the dept num will not change. I have to delete whats in the dept num field, then select a different radio button for the update to occur.
Basically it's not updating...
TIA, any help is appreciated
Tim
anyways, I have 5 radio buttons in a value list associated with a field called "Department Name" I'd like a department number to appear in a "dept num" field based on the dept name radio button the user selects.
the following code in File Maker does this: (case statement)
Case(Department Name = "Administration",615001, Department Name = "Faculty Accounts",615002, Department Name = "Undergraduate",615003, Department Name = "Graduate/Post Doc", 615004, Department Name = "Core Facilities/Services",615005)
However my problem lies in the fact that when a radio button is clicked and the department number then appears in the dept num field, if the user then decides to click a DIFFERENT radio button, the dept num will not change. I have to delete whats in the dept num field, then select a different radio button for the update to occur.
Basically it's not updating...
TIA, any help is appreciated
Tim
Facebook
Twitter