In Joget, lists are templates to display data. The actual data comes from your chosen datasource - forms, APIs, or SQL queries.

For your case:

1. Create two forms: app_fd_products and app_fd_inventory. This creates two separate database tables.
2. Design both forms with relevant input fields.
3. To collect both product and inventory details in one form while maintaining separate tables:
   • Use form grids or subform repeaters
   • These are suited for parent-child relationships like you described
4. For viewing and editing:
   • Create 2 separate lists and select the forms you created as their datasources
   • You can also join them to show data in 1 list if needed
   • or use nested datalist. 

Documentations:

1. Form Grid 
2. Multiple Form Row
3. Nested List Formatter

Hope this helps. 

i made two form already 
and I have two data lists.

 


now this is my datalist 

i want when i press edit to only edit those empty cloumn 


basically if i have two form 

1 form will contain the data trying and the date 
the other form will have the two missing value

the reason for this is because i want the user to actually input the data 

so when he press edit it should take him to the form to edit those empty 

but when i press edit it shows this 

when you click the edit button, it should pass the id of the record in the URL parameters.
if your list is combining data from 2 different tables, you should make sure that the id column that you want to pass is included in the List Builder. you can set it as hidden column.

how do i pass id using URL parameters ?

you need to include the id column in the List Builder.

in the CRUD Menu, when you press the Edit button to edit the data record in your form, it will automatically include the id in the URL parameters.

say that your Form page URL is
<baseURL>/jw/web/userview/<appID>/v/_/product_crud?_mode=edit&id=xxxxx

the xxxxx is the id of your selected record data

how can i pass that id from the first form to the second form ?
would you mind sending a image on how it is done or a link that i can refer to