thx a lot derek! exactly what i was searching for. where can i find good resources to learn all the scripting?
1 2024-06-15 09:55:54
Re: fill combobox with value of the shown record (3 replies, posted in General)
2 2024-06-15 09:33:04
Topic: fill combobox with value of the shown record (3 replies, posted in General)
hey at all, pls see the attached project. when double clicking an entry in tablegrid1 for showing the specific record in a new form, how do i autofill the combobox with the organisation name i double clicked before in the tablegrid1? many thanks in advance for your help! :-)
3 2024-06-06 18:54:18
Re: choose from catalogue (9 replies, posted in General)
thank you so much for the explanation and your kind support, derek! :-)
4 2024-06-06 18:12:30
Re: choose from catalogue (9 replies, posted in General)
okay, got it. i had to set the event for the procedure on tablegrid1.
5 2024-06-06 17:47:26
Re: choose from catalogue (9 replies, posted in General)
hey derek, that's exactly what i was searching for, many thanks! :-) however, trying to reproduce the script in my own application, it does not work. do i have to change some properties of the tablegrid or the fields? many thanks in advance!
6 2024-06-06 15:02:31
Re: choose from catalogue (9 replies, posted in General)
hey derek, thx for your reply! regarding your questions pls see following requirements in red.
1. when creating or maintaining a 'main' record, once you select entries from the 'catalogue' table into your 'main' record, do you then ever make any manual adjustments to 'main_add.memo1' and 'main_add.memo2' or is it always exactly as copied from the 'catalogue' table (the reason for asking is that you don't have a relationship between the 'catalogue' and 'main' tables). --> yes, entering main records, i want to make manual adjustements to every field, also to the two ones from the catalogue. therefore, i am not using relations and comboboxes.
2. does 'catalogue.field1' always get copied into 'main.cataolgue1' and 'catalogue.field2'. into 'main.catalogue2' or can 'catalogue.field1'. ever go into 'main.catalogue2' and vice versa? --> no, they strictly go the the first mentioned fields, no exchange here
3. do 'main.catalogue1' and 'main.catalogue2' always get taken from the same row in the 'catalogue' table? Or, for example, could you select the 'catalogue.field1' value from row 7 in the 'catalogue' table and the 'catalogue.field2' value from row 12 in the 'catalogue' table. In other words, can you 'mix and match' or do 'catalogue.field1' values and 'catalogue.field2' values always come as pairs? --> no mix and match here, catalogue.field1 and 2 are always from the same row
many thanks in advance for your kind help! :-)
7 2024-06-05 20:58:16
Re: choose from catalogue (9 replies, posted in General)
hey derek, thx a lot for your response and the attached example. that's not exactly what i am looking for, i attached an example of my project. when creating a new main entry, i want to choose the records from the tablegrid of the catalogue form to be filled into the red fields in the main entry and saved to the main table by clicking the button.
thx for your support!
8 2024-06-05 18:35:53
Topic: choose from catalogue (9 replies, posted in General)
hey everyone, i‘m new to mvd and i love this tool already. :-) however, i need help with a project. i would like to have a table that can be used as a „catalogue“, consisting of a large amount of records (like text modules/boilerplates). on a form A, i enter different fields and would like to fill the rest of it with the entries of the „catalogue“. for doing this, a new form should open up showing all possible catalogue entries within a tablegrid.
can anyone help me pls.
would this also be doable with records containing child records?
thx a lot in advance