Skip to main content

How can I select the quantity of multiple records in a "linked to another record" field in my table?

M

Hello everyone!

I am designing a table in my Airtable Base that allows my employees to create invoices as records. I would like them to be able to link materials from the Materials table so they can add several materials that they had used on the job within the same field. I would like to know if there is any possible way to select a quantity for the items in the field. For example, if I select an item, I would like to select the quantity I used of that item. Please keep in mind that the field is linked to the materials field as “Link to another record.”

Here is a screenshot of the Invoices table:

I appreciate anyone’s help in advance.

Thank you!

    2 replies

    Kamille_Parks11
    Forum|alt.badge.img+25

    You would need what’s referred to as a “junction table”. Make a new table with link fields to both the Invoices and Materials tables. Each record in this new table will house the quantity of a particular material used in a particular invoice.

    As an example, take a look at this base which uses the table Recipe Ingredients to store how much of each ingredient is used in each recipe:

    A
    Forum|alt.badge.img+2
    Kamille_Parks11 wrote:

    You would need what’s referred to as a “junction table”. Make a new table with link fields to both the Invoices and Materials tables. Each record in this new table will house the quantity of a particular material used in a particular invoice.

    As an example, take a look at this base which uses the table Recipe Ingredients to store how much of each ingredient is used in each recipe:


    It is unfortunate the page has clipped this response and I am unable to view the solution.

    Reply


    Most helpful members this week

    Terms & Conditions