Feb 04, 2025 09:35 PM
Hello,
I am creating a management system for tracking the required materials for projects. In each project, there will be predefined material quantities needed to complete the project. When the work on a project starts, the user will generate a Purchase Order (PO) (third table) and add multiple materials through the interface. I need some help in creating this interface.
The base design is as follows:
I have two base tables. The first one is called the Master Material Base, and the second base is called Jupiter Castle.
The structure for the Master Material Base consists of one table called the Master Material Table, which contains four fields: code, description, type, and unit. I have granted permission to share and sync this table with other bases
In the second base, Jupiter Castle, I have the following design:
(First table): I have synced the Master Material Table into this base.
(Second table): I have created a new table called Material Tracker, which contains the following fields:
(Third table): I have created another table called Quantity Order, which contains the following fields:
Currently, I need help in creating an interface where the user can add the following fields and submit the data. It should then reflect in the base tables.
The user will add:
Use case: When the user searches for the code, the Line ID data should be fetched. The user should be able to select multiple Line IDs and add the order quantity for the selected Line IDs. The user should be able to select multiple Line IDs and add quantities for all the selected Line IDs (Currently, I'm facing an issue with this part).
Once the user submits the form, the data should be saved in the third table (Quantity Ordered table).
Please also suggest if changes to the base tables are required to fulfill this case.
Solved! Go to Solution.
Feb 04, 2025 11:14 PM
How does this look? Each record in on the side would represent one PO, and you'd add one record per line item that would allow you to select the appropriate Material and set the Quantity for that material that was being ordered:
And I've set it up here for you to refer to!
Feb 04, 2025 11:14 PM
How does this look? Each record in on the side would represent one PO, and you'd add one record per line item that would allow you to select the appropriate Material and set the Quantity for that material that was being ordered:
And I've set it up here for you to refer to!
Feb 05, 2025 02:41 AM
Hello @TheTimeSavingCo ,
I have achieved the interface part that you showed in the first image, but I'm not sure how to add the PO # and PO Date when creating a new order.
Thanks.
Feb 05, 2025 11:20 PM