Hi all,
I am beginner to ms access.
I made a very simple form in ms access. The purpose of the form is to show the material list of each Job.
The idea of the subform below is to select the materialcode from the droplist and the remaining filed (such as materialdescription and Unit) would be auto filled.
The issue I am facing is the duplicated values in materialcode column.
I tried to prevent duplicated values by changing the indexed of materialcode in Material Invoice Table to (Duplicates No).
However the relationship between Material Invoice Table and Material List Table is one to many as shown below. So changing the indexed is not valid.
Also, once I change the indexed to (Duplicates No) the remaining fields (materialdescription and Unit) are not auto filled as before.
I do not want to have duplicated materialcode for the same Job No. is there any mistakes in the relationship.
I hope my explanation is clear. Hope anyone could help me.
Regards.
I am beginner to ms access.
I made a very simple form in ms access. The purpose of the form is to show the material list of each Job.
The idea of the subform below is to select the materialcode from the droplist and the remaining filed (such as materialdescription and Unit) would be auto filled.
The issue I am facing is the duplicated values in materialcode column.
I tried to prevent duplicated values by changing the indexed of materialcode in Material Invoice Table to (Duplicates No).
However the relationship between Material Invoice Table and Material List Table is one to many as shown below. So changing the indexed is not valid.
Also, once I change the indexed to (Duplicates No) the remaining fields (materialdescription and Unit) are not auto filled as before.
I do not want to have duplicated materialcode for the same Job No. is there any mistakes in the relationship.
I hope my explanation is clear. Hope anyone could help me.
Regards.