Do any tutorials for Base exist? Specifically:
1) How do I commit the entries in a form to the relevant table? Do I
have the ability to introduce a button that will do the commit and
clear the form for the next entry? I have OO for Mac (with many other
problems) and PC.
2) How do I modify the tab order of fields in the form? The
appearance of the form is somewhat different from the order of the
associated table.
3) Can I create a drop down list in a form that incorporates entries
from a separate table specifically set up to contain accepted entries
for the given field. For example:
The field "Sex" in the TableMain may contain only one of three
values: 1, 2, or 3. A separate table, called ListSex, associates 1,
2, and 3 with the values "Male," "Female," and "Elbonian."
So, I create a form for TableMain. This form includes the "Sex"
field. Can I get this form to go look at ListSex, and give me a drop
down list for "Male," "Female," and "Elbonian," and then place 1, 2,
or 3, as appropriate, in TableMain?
4) Can I create sanity checks in a form. For example:
Say I have a boolean called CaseCreated. If this boolean is Yes, then
the field CaseNumber must have a value. If CaseNumber doesn't contain
a value, throw an error message and refuse to commit the entry.
For bonus points, can I create a sanity check that ensures CaseNumber
is in the proper format? (Say y-z-xxxx, from php's date() function
http://us2.php.net/date, and xxxx is an incremental from a different
database.)
Thanks!
David
--
David - Offbeat http://dafydd.livejournal.com
dafydd - Online http://pgp.mit.edu/
Battalion 4 - Black Rock City Emergency Services Department
Integrity*Commitment*Communication*Support
----5----1----5----2----5----3----5----4----5----5----5----6----5----7--
Amateurs discuss strategy. Professionals discuss logistics.
-- Unknown military analyst on CNN during the 2003 US-Iraq war.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
