Let's say I have three tables A, B, and C. 

- Table A is a domain table (lookup table). 
- Table B is a many-to-many mapping table. 
- Table C is a regular table, containing a fuzzy matched entity. 

When creating/editing a new record for Table C, I want to do an insert into Table B using a known ID from Table A, and the new ID from Table C. 

The reason for this is because Table A is a type table and Table C can have multiple simutaneous types from Table A mapped to it.