> >
> >
> > Question
> >
> > I am working on a boat sale closing form
> > that will print all of the many forms that the
> > different state agencies and bank require.
> > I am at the early stage so I can change anything at this point
> > Right now I have one file that contains all of the information needed
> > Customer info, lien holder info, boat info color length, propulsion etc,
> > Is there a compelling reason to break this into several files? Lien holder file, customer file, boat file, etc The table will never be huge maybe over many years it will Have thousands of records not millions not even hundreds of thousands
>
> Professional software developers are supposed to know to normalize data files. This should be a new topic.
>
> The sale is one file. The customer is another file. The boat may have been sold with extras. These could be in yet another file. The boat base price plus the sum of the extras is the final sales price on the invoice. Very typical stuff.
>
> If you have all data in one record, multiple people cannot work with the record at the same time.
>
> Mike Yearwood
>
>
>


I am not sure how to respond