I am working on a Custom Application. Here I have 2 tables, table A and table B. We are using a record producer to create a request in Table A. In the same record producer we have a set of variables containing 10 variables related to Table B. Curretly, in the producer script, we are populating the Table A's created record's sys_id to the record in Table B. Then we have a related list on table A to show the records of Table B.
Now what we require, we want the number of sets of variables to be dynamically shown / be available as per the number selected in a drop down field whose upper limit is 20. in the below screenshot Line Items refer to Table B.
Also the same number of records should be created in the Table B. And visible under related list on Table A.
Therefore, if the user selects 12, there should be 12 sets of variable available on the form and on creation, 12 records should be created in Table B.
I have thought of creating each variable individually and then controlling their visibility using client script. But this requires lots of Insert and stay. I mean for a set of 10 variables, I have to create another 190 or more. And I dont like this solution, it requires a great amount of work. If anyone can provide a more simpler / technical solution. That would be really helpful.
Regards
AirSquire
