This probably has a very simple solutions but I have been racking my brain for 2 days on this and have had no headway. I have done this before in another database but cannot get it to work correctly this time.
I have a writer form with a main form and a sub form.
The main form contains customer information.
The sub form contains project information and a table that reflects information entered in the subform.
One customer can have multiple projects is the basis of this form.
I have created the relations ships in the tables but I keep getting an error message about Duplicate Entry.
On Table job info the Client id is the primary key
On Table projects the id projects is the primary key
I created a 1 to many relationship between Client id on Job info and Client id on projects
I am working on windows 10
libre office 7.3.2.2 (x64)
Java 8
Thanks in advance for any help or advice on this.
See attached images;
