Project for all (Page 1 of 2)

AD1408
Hello,

Thank you for the project.
In the moment I start to write book for non programmers, how to create database structure and applications using MVD.
Currently the book translated to English (many to Yann Yvinec), I need just change screenshots in the book and then will put it in the forum.

I have tried to reduce many forms in design level as we don't have a treeview in MVD yet.

Could somebody answer  please, is it possible to have functional form as detailed on the image below?

http://prnt.sc/ca29uv

Hello AD1408,
Apologies if I'm misunderstanding your question, but maybe the method I use for look-ups will be of interest to you.
I do all my lookups with a single table (to hold my look-up keys and values) and a single form that I use both to display and maintain the look-ups;  it has saved me so much time.
It's probably easier to attach a sample project to show you (in this example, I have 9 'look-ups' all created and maintained using just one form). 
The things to look out for particularly are:
1.  the multiple relationships created in the data structure pointing to the attributes table
2.  the calculated fields to show a text value rather than a record-id
3.  the use of the combobox filter property (so it shows just the rows that match your key)
As you can see from the attachment, all this is achieved using standard MVD and no script.  Also, if your project changes and you need to add new look-ups, the structure is already in place so you are future-proofed.
Depending on your project or number of users, you might want to password protect access to the look-ups maintenance but that is easy enough.
Hope this helps or at least gives you some ideas.  Please get back to me if you have any questions.
Derek.

Hi AD1408,
A simple demo is attached for you.  For example, I want to create a project with information about people. 
It has 3 lookups (but obviously it can be many more) for 1.eye colour, 2. height and 3. zodiac sign.
Using my attached project, these are the stages you must follow;

screenshot1.jpg
1.  create a table ('people')
2.  create a table ('lookups') with 2 fields ('lookupkey' and 'lookupvalue').
3.  create 3 relationships from the 'lookups' table to the 'people' table (1 relationship for each lookup) .
4.  create 3 calculated fields to retrieve the 'lookupvalue' field (1 calculated field for each lookupvalue).

5.  create your forms (form3 and form4 are for the lookups - you will only ever need these 2 forms even if you add 100 more lookups!).

screenshot2.jpg
6.  set the foreignkey and fieldname properties of each combobox and add the filter property

screenshot3.jpg
7.  add data to your 'lookups' table

screenshot4.jpg
8.  when adding data to the 'people' table, your comboboxes should retrieve the correct lookupvalues.

Usually, this would require 4 tables and 6 forms;  this way, it requires only 2 tables and 4 forms.

I am not sure what you mean when you write "I have too many lookup items to put in one list....".  Remember than when you add the filter to the combobox property, you are, in effect, creating sub-lists that would contain the same number of rows as doing it the usual way.

Hope this helps,

Derek.

I have reduced the scope of 101 business project to bare minimum but I cannot get it working fully. It needs some scripts in certain areas and I don't know the coding. Learning pascal from zero would take some time for me. I cannot allocate enough time to do it. This project was an attempt to do very basic accounting for my tiny business. It's not a commercial one.

I thought If I do the forms, db tables, and settings (as much as I could do) other knowledgeable members may fill the missing bits. Then it'd have been used by other members also according to their needs. Perhaps I was bit naive to suggest to do a work for free. However, I come across couple of kind members such as JB and Derek in this community offered their help freely.

So guys, is there anybody can complete my project? I'm willing to pay for their help. Please contact me. My forum email is valid one.

I have sent couple of emails to Dmitry at support to do this project for a fee but to date I got no reply. Perhaps he didn't receive them?

Hi Derek,

Great stuff. Thanks a lot....................

Having totals in a field for invoice purposes, from totals field I can add tax, gross, discounts etc fields and calculate final balance.
Grid totaling also is very useful on different circumstances. Thanks for this too. However, screen cap about grid totaling seems didn't come through, unless I'm getting blind or something.

"If I have some time, I will try and re-work a bit of your project to show you the approach to lookups with just one table that I use.  I can also include the way I create a 'help file' and a simple 'menu structure' that I often use, if that would be of any interest to you."
BIG YES PLEASE!

Hi Derek and JB,

Thanks Derek. You were right, screen cap was in the project folder. I was looking for screen cap in the post, didn't notice it in project folder as I was so excited to see the totals working. My apologies....

JB,
Thanks for tgrid columns script  below:

procedure Form1_TableGrid1_OnChange (Sender: string);
begin
     Form1.TableGrid1.Columns[0].Alignment := taRightJustify; // first column
     Form1.TableGrid1.Columns[1].Alignment := taCenter; 
     Form1.TableGrid1.Columns[2].Alignment := taLeftJustify; 
end;

It produce and error. I added
begin
end.
at the end but it didn't make any difference. Perhaps you could add tgrid column data alignment code to Derek's totals project (which totals  are working nicely)

Thanks a lot Derek.... Appreciated very much.