Skip to main content

Easier way to create new fault

  • August 5, 2024
  • 1 reply
  • 1 view
E
Forum|alt.badge.img+8

Hi,

I have three tables:

For faults
For suppliers
For combining the fault and supplier tables so I can have multiple suppliers per fault and different costs for each supplier. (Every record represent a supplier in specific fault).


Currently, when I open a new fault from the interface, I need to create a record for the fault and then create a record in the table that combines the fault and supplier tables. (So I can choose which suppliers belong to that fault + add thier pricing)

What is the easiest way to create a new fault? Should I just submit two forms: one for the fault and one for the table that combines faults and suppliers? Or is there another, easier way?

Thanks.

1 reply

A
Forum|alt.badge.img+13

It sounds like you have a junction table, and you should be able to create a new record for the fault from within that table by clicking the + button in the linked field when adding a record, then selecting "create new record" at the bottom of the menu.

If you're generating these records via form, I believe you can enable or disable the option to create new records for the faults when linking to the faults table in that form.

Reply


Most helpful members this week

Terms & Conditions