Question on Access 2000/XP QueryLocked
In Access 2000, I build two Tables, for example, one for Items Basic Info: part number, description, and so on; another for Structure: ID, parent part number, child part number, Qty.
Then I have a Query, select parent part number, its information from Basic Info table; based on this query design a Form.
Now I find one problem, let?s say, 1 parent item has 3 child items; then in the Query, Select: parent part number, description, other basic info, it shows number of records 4. After I modify a little, Select Distinct: parent part number, description, other basic info, it shows number of record 1 (this should be correct), but then I cannot add new records: the add record button becomes unusable.
How can I make the records distinct, while in the meantime can add new records?