I have a small section of an app that allows users to add parts to a job, so I have several tables a Job Table, a Part Table and a Job_Part table that links jobs to parts.
There is a requirement to add ad hoc items not in the parts table like consumables for example, and I can't figure out the best way to do it. The data has to end up in the Job_Part table, and I don't really want to add to the Part table and have to generate a part No.
The row would be effectively orphaned in the part_Job table. The app is not big so some leeway on strict performance design
Does anyone have an idea on how to best achieve this?