I have a form that allows additions of 'raw materials' to added to tbl_formulas. However, Access stops me because there's a one-to-many relationship that prevents items not on tbl_rawmaterial from being added. I'd like Access to automatically add what's entered in [Raw Material] on this form, to tbl_rawmaterial if the item doesn't exist. Is that possible?
To be more specific,
If entry made to Forms!frm_CurrentFormula![Raw Material] does not exist in tbl_RawMaterial.[Raw Material], add it.