I have a Category table and a Sub-cat table which are maintained by a form/subform arrangement.
Each Category may have 1 or more sub-cats (or none at all)
I have another table which contains fields for Category and Sub-cat each of which are selected from a drop down list. They are selected seperately but I want the sub-cats list to only contain the subcats that are valid for the entered category.
I achieve this by having a query to select the sub-cats with criteria [Forms]![Formname].[cat id].
In form view everything is fine.
I have 2 issues.
1. When the form is viewed in datasheet view (which it mostly is) I only see the values for sub cat for those records with matching categories. The records with other categories show as a blank field in sub-cat.
When i move to a record with a different category, the sub-cat values for all records with that category appear and the sub-cats for all other categorys go blank.
2. Accepting the way things are in issue 1, up until recently I have been able to filter by sub-cat and sort by the sub-cat field in datasheet view but now when I try to do this no records are shown.
Any help with either or both of these issues would be appreciated.
Phil
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (1) |
Tidak ada komentar:
Posting Komentar