I have a Two fields Invoice Number & Status. At present I already have Invoice Numbers entered to my Invoice Number field. How can I make my Status Field so that It will show Invoiced.
Sounds like what you need is a calculation. If your status is only really going to ever be "Invoiced" and/or some other option that's predetermined, you can make your status a calculation field type. The calculation would be something like:
if ( not isempty ( Invoice Number) ; "Invoiced" ; "" )
This checks whether something is entered into your invoice number field, and if so the status becomes invoiced.
If you want the user to be allowed to enter other statuses into the field, you can keep it a text field type, but use the auto enter calculation option in the auto enter options of the field.
The auto enter calculation is very similar:
if ( not isempty ( Invoice Number) ; "Invoiced" ; self )
Ensure the option to "do not replace existing value of field if any" is unchecked.
So what this will do is allow you to type into status field, but whenever a value exists in the invoice number field, the status will be "Invoiced", if nothing is in the invoice number field, you can enter whatever you want.
Make Status field to calculation type, then
Case ( not IsEmpty ( Invoice Number ) ; "Invoiced" )
show the status.
Retrieving data ...