Hi, I'm only new to DBMAN and scripting, I'm quite impressed at the support and help available which lead me to this program. After playing around I found that I need to add a extra "ADD" choices. basically I need to have more then one ADD buttons on the Main Menu.eg ADD car, ADD truck..... ADD bike etc, which will call in the correct Add a New Car Record, Add a New Truck record etc etc with the approiate feilds to fill out.

Any help would be great..!!

You may want to consider using the relational mod using a main database to store user information, and then creating separte databases for cars, truck, bikes, etc.

The mod is available in the resource center or on JPDeni's site at http://jpdeni.com/dbman/ and she also has included a demo database to help you get started.

This way you could have fields specific to the type of records being added.

Hope this helps

Unoffical DBMan FAQ
http://redundantcartridge.com/dbman/

Hi Loisc,

Have checked out the mod you recommanded and agree it does what I want, Iwould really like to keep it

in one DB if possible, if it to much work to do this I understand and thanks for the quick turn around.

thanks heaps

colin..

If you want to keep it all in one database it might be the easiest to just setup a category field where they would select which type of vehicle (?) they are adding to the db.

Then on your add form you could put all the same type fields such as price (that would relate to all records) in a main portion of the form. And then label different areas of the form for the specific vehicle type. Does that make sense.

For example:

Choose which category you are adding this to:
auto, truck, bicycle, etc.

Complete the following section for all categories:
year, make, model, price, etc.

Then create sections for each type of vehicle and add the fields specific for that vehicle.

------

You could create different add_form but it would be much more involved and you would still need to add all the fields from the .cfg file in each form as either visible or hidden fields. Check out this thread reference:

Thread: http://gossamer-threads.com/p/100986
Subject: Multiple Forms
Elle - 17-Aug-00

Hope this provides some ideas, perhaps someone else will come along and provide more ideas.

Unoffical DBMan FAQ
http://redundantcartridge.com/dbman/