- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Aug 05, 2024 05:08 AM - edited ‎Aug 05, 2024 05:25 AM
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.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Aug 09, 2024 09:58 AM
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.
