- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎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:
- Line ID (Primary formula field)
- Level (Single Line Text)
- Section (Single Line Text)
- Code (Linked record with the first table)
- Description, Type, Unit (Lookup fields from the first table)
- QTO
(Third table): I have created another table called Quantity Order, which contains the following fields:
- PO # (Single Line Text)
- PO Date
- Qty Ordered (Number)
- Vendor (Linked to another table)
- Code (Linked to the second table Material Tracker)
- QTO (Lookup)
- Line ID (Linked to Material Tracker)
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:
- PO # (Text)
- PO Date
- Vendor (Select vendor)
- Code (Required as input text to search for the Line ID)
- Line ID (Based on the entered code, fetch the Line ID)
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.
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎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!
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎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!
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎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.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Feb 05, 2025 11:20 PM
![](/skins/images/75AB00B4920FD2D67A8CABF77C9DECC4/responsive_peak/images/icon_anonymous_message.png)