Good way to allow easier updating of multiple reco...

[eranggg]

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.

[Alyssa_Buchthal]

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.