I am looking for suggestions on how to compute the cost of an assembly configured by a customer through a form. I think I want to create a junction table based on the form responses but have not found a way to do this. Linked records seem to be onl...

Hi - wondering if there is a more efficient way to track order status for individual items on a BOM. I have set up one table that tracks the current status/timeline of built to order bicycles and another table that lists all the components on the or...

I have a table of assemblies that needs to compute the price of the assembly based on its component costs, with the components are entered via a form view. EX: Rows: Assembly #support Columns: Components A, B, C, … --> Calculated Price Assembly_1: A1...

We have a form for customers to select components for an assembly. As is, the form just shows the description of each component. It would be ideal to show the customer an image of the component (which we already have stored in the table) to help th...

I have built a form that we can send to customers to spec a custom bicycle wheel. It works fine for them to enter the details of what they want us to build, then makes life easier on our end as the database computes the price of the wheel. I would ...