Just now I rectified my mistake of Amit sir suggestion on 8/2020 with silly mistake.Some times "batti gul ho ja ti hai to jalti hinahi" Set as : If $$IsEmpty:$$Value then "Regular" else $$Value. i did not put space between then and "Regular" . Regards
You are absolutely right Sir. Sir, I have a doubt. Can I have a conditial tables for a field based on the value of another Field? For example [Field: Key Factor fld] Use : name field Table: <TableNameA> Show table always: Yes Storage : KFStorage [Field : Conditional Fld] Use : Name Field Table : If $KFStorage= "X" Then <TableNameB> Else <TableNameC> Show Table always: Yes Storage: ConditioonalFieldStorage
Study many of the Fields in Developer and you can learn from it. Study --- VCH StockItem in Developer......... Syntax is----- Table : TableA : NOT ##ContraCondition AND @@IsSales Table : TableB : ##ContraCondition AND NOT @@IsSales
Thank You Sir, It Worked for me. And it made a big relief for the works. I am new to the TDL Development. This group is really encouraging and helping me a lot. Thanks for your kind support and suggestions
can i know the source code for drop down list for dispatch details as i need to enter transporter name and vehicle number if drop down list according with group ledger master is selected will help in typo error
@Amit Kamdar Can you elaborate and help me out on this coz I tried what u suggested and achieved to the point of adding but something is wrong as it shows on a single letter display once i press the key at the field. Then if i input the data it says accept i press yes but the list name doesnt get added I think I am missing a syntax or a action but due to my limited knowledge not able to complete this. Pls Help This is part of my code [Field : Salesman] Use : Name Field Width : 20 Storage : SalesmanName Table : Typ Show Table : Always Set Always : Yes Key : NewSalesman [Table : typ] Title : $$LocaleString:"SALESMAN" List Name : "SAIF" List Name : "SHREYAS" List Name : "PRADEEP" List Name : "SRINATH" List Name : "YOGESH M S" List Name : "YOGESH R M" List Name : "DBSALES" Format : $Name,15 [System:UDF] SalesmanName : String : 2 [key : NewSalesman] Key : Alt + 3 Action : Alter : typ3 [Report : typ3] Form : Typ3 [Form : Typ3] Part : Typ3 [part : typ3] Line : Typ3 [line: typ3] Field : typ3 [Field : typ3] Use : Typ
So far you are on right track....... continue with the REPORT : typ3 Define the size of report, the PART, LINE etc.....in the Field for Salesman ...define storage ........ and also make a aggregate collection. refer to this POST and you can learn a lot from it......... http://www.tdlexpert.com/index.php?...es-report-under-construction.7299/#post-45596
@Amit Kamdar I guess I did not outline what exactly my query was properly. I have achieved what I wanted to do with regard to salesman mapping etc. But my question is regarding addition to the drop down list. I get the drop down list and when i press Alt + 3 which is the key i have defined it opens a prompt and inputs data and says accept but after that that data does not get added to the drop down list. My Basic Question is How do I define the Key Correctly such that It adds another Name to the predefined list typ without having to change the TDL every time to manually add a name to the list. Once the Salesman is added it should be automatically available to pick from the drop down list. i dont need any report or anything else .. I will use the default reports to fetch the storage value along with buyer name when I take a report. The report part is what I saw people have done to make the Key Work. If the list can be added to without having to define any report or part thats also okay for me. I hope my query is clearer now. Just need to be able to add a new value to a drop down list with the key
I understood clearly what you need ....... and drew your attention to the code, .......in that code....... the button takes you back to the creation of Salesman list....... there is another method you can adopt......... that is LIST ADD ........ kindly refer Developer for the same .... you can add a new LIST through a function.