I have a form that consistes of several fields from various tables. (3 fields from 10 different tables)If a record on the form is blank is it possible to enter the information on the form, and have it generate a serial number(in the original table)? And in doing this, will it check to make sure that the record entered doesn't already exsist in it's original table? (Basically I have several contact lists, and one form displaying the related contacts, they each have serial numbers (auto-generated when I entered them the first time))

On a side note, sometimes when I delete one record, almost all the records in my database dissappear

Hi ATLBryan,

Start by doing a Search for the following in the Online Help, available under the menu Help when FileMaker is open.

[color:blue]Defining automatic data entry

Replacing the contents of a field

Deleting records

Let us know if you still have any questions.

Lee

Thanks for the suggestions. This is my first database and is turning out to be quite a project, do you know if there are people who make databases or other people?

There are several on this Forum that I'm sure will offer their services to you. Post your needs in the Classified Topic Area, include the specifics of your project, and how they can contact you Off List.

HTH

Lee