Inventory database

[playaslaya]

I'm creating a database that will include an inventory of various Golf Carts that we sell. I'm trying to design a form that would have fields such as Make/Model, serial number, price, and features. The problem is that for features I want the form to add a new field for each additional feature that I type. Example:

New Blue Paint
New Aluminum Rims
New Light Kit
New Lift Kit

I'd like them to be in separate fields so I can create a report that would print signs to be placed on each particular golf car. Any help would be greatly appreciated. Thanks.

 

[afloyd]

One way (and probably not the best) is to determine the maximum number of features that could be on a cart. Then in your table have that number of fields available (i.e. Feat1, Feat2, Feat3, etc.)

Then on your form have a section with the text boxes so that the features can be entered. Then you have all your features for each cart in separate fields.

Your report can then mirrors the data entry form and has space for the maximum number of features.

-HTH

p.s. I have a friend that is a golf cart salesman. He hooked me up with tickets to the U.S Senior Open this year. It's always good to have connections.....

 

[pbuethe]

The features do not have to be separate fields. You can use one field in a separate table which has a many-to-one relationship with the main table. Then on your main form put a continuous
subform which is based on the features table.