Page 1 of 1

Appleworks database construction

PostPosted: Mon Apr 23, 2012 4:33 pm
by sdoetsch
I need to create a database with a duplicate set of fields for 2 different people living at the same address but not necessarily having the same first/last name, email, cell phone, etc. I have tried making one field name an initial cap and the other all lc. I have also tried adding a numeral or a letter, eg: name 1, none of these options created a second set of fields. Appleworks for Dummies does not give a suggestion. Any Ideas?

Re: Appleworks database construction

PostPosted: Tue May 01, 2012 1:31 am
by Barry
What steps do you follow when adding these new fields?

The usual procedure is as follows:

Open the DB document and show Layout 1.
Go Layout > Define fields to open the Define Database Fields dialogue.

Enter the name of the first new field into the Field Name box
—note that the name must be different from any other field in the DB. If you have a field named "First", to contain the first name of the first person, you can name the similar field for the second person "First 2"

Check the Field Type pop-up to ensure that the correct type is chosen (Text for this field). Change if necessary.

Click Create to create the new field. Appleworks will add it to the bottom of the Field list, and place the field and its label at the bottom of the list of fields in the Layout.

Type the name of the second new field (eg. "Last 2") into the box. Click Create.

Repeat for the other fields that you are adding.

When all are added, click Done to exit the dialogue and return to Browse mode.

Save before continuing.

If you want to rearrange the fields on the Layout, go Layout > Layout to enter layout mode. Select and move the fields (and their labels) on the layout as desired. When done, press shift-command-B (or go Layout > Browse) to return to Browse mode.

Save.

Enter data.

Remember to Save before closing.

Regards,
Barry

Re: Appleworks database construction

PostPosted: Fri Jul 05, 2013 11:42 pm
by davidchristmass
Barry wrote:What steps do you follow when adding these new fields?

The usual procedure is as follows:

Open the DB document and show Layout 1.
Go Layout > Define fields to open the Define Database Fields dialogue.

Enter the name of the first new fiel d into the Field Name box
—note that the name must be different from any other field in the DB. If you have a field named "First", to contain the first name of the first person, you can name the similar field for the second person "First 2"

Check the Fi eld Type pop-up to ensure that the correct type is chosen (Text for this field). Change if necessary.

Click Create to create the new field. Appleworks will add it to the bottom of the Field list, and place the field and its label at the bottom of the lis t of fields in the Layout.

Type the name of the second new field (eg. "Last 2") into the box. Click Create.

Repeat for the other fields that you are adding.

When all are added, click Done to exit the dialogue and return to Browse mode.

Save before con tinuing.

If you want to rearrange the fields on the Layout, go Layout > Layout to enter layout mode. Select and move the fields (and their labels) on the layout as desired. When done, press shift-command-B (or go Layout > Browse) to return to Browse mode.

Save.

Enter data.

Remember to Save before closing.

Regards,
Barry



First off assume your using Appleworks 5, I suspect 6 has the same functionality in this capacity, but am not sure, as it seemed to me worse on Mac 9 than the earlier version I stuck with.

Use the spread sheet part of Appleworks, in one single horizontal row, of a spreadsheet, put in the fields you require, with some temporary info, for example, along row 1 at cell A name1 B surname1 C name2 D surname2 E house name number, F Road or Street, G District, H City, I Province, State County, . . . . etc.

Duplicate that field to row 2.

Save the file as tab delimited, text.

Switch to Database mode.

Import the text file, you made, that will give you two records, both with the info you put in the fields of the sheet.

Go to layout mode

Pull up the menu define fields, and Enter a field name for all fields, obviously that has to be different, but for example, the names you entered in the cells, seem like good field names.

Adjust the fields on the layout page, ie make them bigger, smaller, place them where you like.

Stick a background on the card, cut and paste I guess, then send it to back.

Switch back to Browse mode, and there should be your card, as you want it.

You will have to use inverse logic to find the selected fields not containing the search field and omit them from display. It does my head in, thinking backward, but there is a way, I am sure.

And its helpful to know you can put a field name that contains data, into another field, so say name1 is where you want to search, having name2 field looking at name1 field, ie containing that field reference, might get you somewhere, you never knew you would get, and all that stored in a search procedure, now if you use the clipboard, the keypress control v inserts in the field1 whatever you want, so just copy the search citieron, to the clipboard, before running the saved find routine, and I am sure, you will get nearer to where you want to get to, even if, only part of these suggestions, seems helpful.