As shown in figure, I think the main data table ID associated with secondary data table ID, you need to set the ID for the index, the main data table do not have what problem, but in the secondary data table, because there are repeated ID (e.g., 85001 has three), how to set up the index???

CodePudding user response:

The original secondary data table is above such



I set up the index, marked *



They became so,,,,,,,,

CodePudding user response:

This is the problem that design? Choose for duplicate ID field when the index is reasonable