NetMinder,
Here are some examples of how I accomplished these tasks. You will need to replace the element names I used for yours
Quote:1. The "Order Date" field in the Sesame Database does not Auto fill with the current Date.
You will need to add Sbasic commands to the element order date. The example below might be a start. This works for me.
// This enters Todays Date if record is @new
If @isnew and Dateentered = "" then
{
dateentered = @date
}
Quote:2. The "Reference" field in the Sesame Database does not allow for typing an input, but that's good. But it also doesn't automatically give me the next sequencial number, as it needs to.
This example is what I use
/*
This says that if I am adding a record that is new to the database and the
patientid is empty that the patientid will be the globalvalue NextCustRecNo plus
1 and then it is updating the globalvalue so it will be available with the
correct number when it is needed next.
*/
var GSNextCustRecNo as int
If @isnew and PatientID = "" then {
PatientID = @ToNumber(@GlobalValue("NextCustRecNo")) + 1
GlobalValue("NextCustRecNo", @Str(PatientId))
}
Quote:3. I have the form the way I need it, but everything is really close together. I need to find a way to make the form larger, so I can spread my fields out, to make the form more easily readable.
There are numerous ways to accomplish this. One way is:
Select an area on the layout canvas that does not have an element and click
Go to property editor and click the tab labeled position
Enter numbers in height click arrow
Enter Numbers in width click arrow
You might want to read some of the earlier posts. Some of this stuff is explained in a little more detail.
Happy coding.