I'm not sure how to go about it, so I thought to ask for help.
I have a form that inherits a IDClient. The form has a subform with a recordsource made of two tables joint together (Articles left join Sales).
Every client can have some 'sales %', always not more than one for each article.
Now, I have no prob to visualise for each client the list of all articles with % sale where resent else a null/blank value.
What I wanted to do is having this table with the prices of all articles as reference and the possibility of editing or adding a sale % if needed.
What I found out is that a joint table isn't editable. Any suggestions about a workaround?? thanks
I have a form that inherits a IDClient. The form has a subform with a recordsource made of two tables joint together (Articles left join Sales).
Every client can have some 'sales %', always not more than one for each article.
Now, I have no prob to visualise for each client the list of all articles with % sale where resent else a null/blank value.
What I wanted to do is having this table with the prices of all articles as reference and the possibility of editing or adding a sale % if needed.
What I found out is that a joint table isn't editable. Any suggestions about a workaround?? thanks