Creating Parent record from Child Table
Please note the screenshot I have posed of my Relationships.
I have a layout that allows the user to create a new record in the POS Receipt Header.
When this record is created I want to automatically create a parent record in the Daily Sales Summary table and the Channel Daily Performance table if it does not already exist.
I allow the creation of records in the parent table from the child table.
However, the creation does happen.
Do I have a flaw in my database design or am I doing something else wrong?