Using same table for textbox results and browses

[Mike Wilson]

Re: Using same table for textbox results and browses

Robin,
I was in the wrong form. Yours works well except at the very beginning with both tables empty. Adding a new department to a completely empty table doesn't become available in the variable field drop down. Don't know why, but it doesn't.

[aaronhaul]

Re: Using same table for textbox results and browses

Thank you guys for all your contributions. It was really appreciated. Your help actually gave me more ideas to keep up with my project.

I do still need your assistance, though, regarding the input fields: Dept_ID comboBox and Specialty_name textBox. I edited the Field Rules for both fields on the Specialty table making the fields "Required", so that when data is entered on the dept_id comboBox without inputting data on the specialty_name texBox, it will prompt the user that the specialty_name field is left blank, and vise visa.

It actually works fine though, but the popup message Alpha 5 generates gives a default value for the message (Field is required: DEPT_ID for Department textBox, and Field is required: SPECIALTY_NAME) and its not so user friendly with an error popup on a form field.

Is there a way I can indicate blank field without using a dialgoBox, like making the textBox and comboBox field background becomes RED or so, indicating that the field is left blank, and it can't be submitted, saved or left empty without inputting data first? I tried using ISBLANK("FIELD_NAME") on the Color Equations Genie on Field Properties, but I'm not having any responses. I don't know if I actually set it properly.

Any ideas?

Aaron


UPDATED:
I just used the codes:

case(isblank("DEPT_ID")=.F.,"black on white",.T.,"black on Red")

case(isblank("SPECIALTY_NAME")=.F.,"black on white",.T.,"black on Red")

to give the field color red if left blank. It still saves the data on the form though the DEPT_ID is left blank. Is there a way to give the blank field focus when it's left blank, until its data is inputted?

[Mike Wilson]

Re: Using same table for textbox results and browses

Aaron,
You will read on this board that most experienced developers will not use the required field rule because it in neither developer friendly nor user freindly. What is often used is the form CanSave event to check for the presence of a value in a form field, and cancel the save event, fire a ui_msg_box message and then place focus back on the field of concern (topparent:fieldofconcern.activate()) when the required field is empty. This tends to work pretty well.