How to be able to enter data in address field in sales table and in contacts table
I have set up a new sales table on my database. This works well with my line items table and my inventory table.
I would like to be able to enter my customer's address when I make a sale in the sales table and for the address to be automatically entered into the contacts table. I would also like to be able to enter the address in the contacts table too and then be able to type the customer id into the sales table and for the address just to appear.
At the moment the relationship is allowing for the creation of records in both the contacts table and the sales table via this relationship.
But its not working for me.
Can somebody tell me what am I doing wrong?