Search options (Page 25 of 34)

Any other improvement with this version?   

Do you think it would be a good idea to share some snippets?
Kind of a snippet KB

It may help everybody in progressing with the creation of wonderful applications. What do you think?

I found this which confirms the lack of Unicode management (utf) in SQLite http://forums.devart.com/viewtopic.php?t=18222
alongside this http://site.icu-project.org/

Oh!

I would like to see a screenshot of your method since I tried with no luck! My buttons are still grey!

As mentioned by JB, you could also store your project on a shared folder (as I do for a corporate small app)

I have been trying to understand your need but I still do not get what you are trying to achieve, honestly speaking...  I tried to re-design your project but I am lost with the context. You want a database to list your vehicles but I do not understand the purpose of the tables Accident and Inventory, your form  TruckOne is looking for information into Accident which makes no sense to me when this form pops up when clicking on a button which looks like adding a vehicle.

What do you mean by inventory in multiple locations? What do you call inventory actually We all have our own words and our way of thinking

Ok, I think you did not get what a database is actually

You want a truck inventory, then instead of thinking the trucks should be separated, try to imagine your database as a big garage. Would you fit the garage inside each vehicle or the opposite?

I will try to design something very basic with what you sent above.

You were maybe misled by the design of a table, try to imagine that the lines are actually columns in an excel sheet.

The purpose of a database is to gather all information of same kind at the same place.

Designing the tables and relationships is the most important part of your database, you have to think about what you want to see, how you want to see it, how information should interact and how you could do it in the simplest way possible. Always think KISS ( keep it simple stupid) and avoid redundancy.

Remember that in a database, a record is a line with several columns, a relationship is the id of another line in another table. We use relationships to avoid information redundancy and to ease the maintenance by splitting the information. It is easier to maintain a small table (adding, removing columns, modifying content meaning, etc...)

In your case, you only need one table Trucks and maybe draw something on the paper to clarify your view.

All your trucks will be in same table but can have different properties

What is the departure point? Trucks? Accidents? Vehicule input? Vendors? Parts?

If you struggle too much, you could also submit your project to the forum and we will help you.

I think I understood what you want to achieve, could we see how your database looks like please? Click on the button next to "New Table" in MVDB and send a capture of it.

I think you are missing the correct use of relationships and comboboxes or you are not using "Show Record" property for your button. There might be a design issue as well