On Tuesday May 16 2006 07:38 pm, Gil Hoellerich wrote:
> I'm using the latest version available for downloading.(v2.....)
> A restatement of my problem concerns the database. How do you add a
> field to an existing table?
>
> What is the purpose of the form? I notice this switches back to writer
> which has an option to add a field but that is greyed out on my
> software.
>
> Gil
> [EMAIL PROTECTED]
Adding a field to a table:
* Open the database file.
* Under Databases, click the Tables icon to highlight it.
* In the list of Tables, right click the table you want to change.
* Click Edit from the context menu.
* Enter your additional field in the Field Name column.
* Change the Field Type to fit your field.
* Make any additional changes necessary in the Field Properties section at
the bottom of the window.
* Save and then exit the table.
Purpose of a form:
This is easier to demonstrate than it is to write. For example, I use
a database for creating my weekly grocery list. I had the grocery items in
the same order as they were in the store. Recently, the grocery store I
had been using closed. The store I am now using has a different order for
their items. All I did was to rearrange the order of the fields on the
form. Now the fields are in the same order as the items in the new store.
Oh yes, I have a nice graphic background for this form.
Forms can contain a list box which references a table. (The entries
for this field are selected from the table.) One of the fields could be a
picture as in a personnel form. (This is in a relational database.)
Dan
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]