Form problems

[hnorgaar]

Need a bit of help with a form on a car database im creating which include a multi field (Might need a better idea there), anybody willing to help me?

 

[Joe4]

Welcome to the Board!

I think we will need a bit more information in order to help you. But I would caution you about using the "multi-value" field data type. Though Access starting allowing it a few years ago, I would recommend avoid using it, if you can. It really kind of violates the rules of data normalization,which can be problematic for relational databases. And other relational databases, like SQL and Oracle, do not allow this sort of thing. So if you ever needed to convert your database to SQL at some point in the future, you wouldn't be able to do so without redesigning stuff and fixing up the data.

There are usually other, better ways of handling it, usually by making another table that has a one-to-many relationalship with the main table.

 

[Micron]

cross posted with answers

Help with form

I have some difficults with a car database im doing and is looking for help. Im using cascading combos to locate the right car and have a multi value field there to combine horse power in a subform linked to the car base i want to create. Also need to autofill in some fields from the mainform...

www.accessforums.net