Cascading keyword

[DevAccess]

Hello

I have below situation.

I have few keywords which I manage to be done by admin in admin section of the project.

I have to define category as below and same to be present to end user in combo box format.

One product No could have one task but could have multiple projects associated with product number.

Therefore I would like to design this is in such a way that admin can enter product number and can enter one task and can enter multiple project assoicated with product number and same should be available to user in form of cascading combobox.

Please assist how to achive this, also admin delete or modify any of the value at any given time.

Thanks

 

[The_Doc_Man]

The back half of your problem is almost nothing. Once the association is stored in a table, it WILL be possible for users to see the list of project associations.

The front half of the problem is tougher to manage because you have to have projects and products before you can make an association. I believe this is a case for what we call a Junction table. You can look up articles in this forum using the Search function that is in the dark ribbon at the top of the page. You will be able to find many articles on such tables. If you have product/project associations stored in a junction table then it becomes relatively easy to prepare for selection.

Note also that I found your description a bit hard to follow. We understand that USA/UK English might not be your first language and we try to understand, but sometimes it is more difficult. Therefore, if it seems to you that my answer was not responsive, I apologize for misunderstanding your question.