Although I believe this to be a Newbie question, I can't figure this out. Maybe you can help.
I currently have a table column ("Category" which lists categories and their abbreviations. The data was entered in a value list (i.e. "Firewall - FW";"Policy Processing - PP", etc). Due to some coding I am doing with my forms, I discovered a need to have this information in two columns.
What I would like is to have two columns ("Category ID" and "Category). When a user selects an abbreviation ("Category ID", the "Category" column would be appropriately populated automatically.
Is this possible? Again, I would appreciate your help as I cannot figure this out.
With thanks in advance,
Ben
I currently have a table column ("Category" which lists categories and their abbreviations. The data was entered in a value list (i.e. "Firewall - FW";"Policy Processing - PP", etc). Due to some coding I am doing with my forms, I discovered a need to have this information in two columns.
What I would like is to have two columns ("Category ID" and "Category). When a user selects an abbreviation ("Category ID", the "Category" column would be appropriately populated automatically.
Is this possible? Again, I would appreciate your help as I cannot figure this out.
With thanks in advance,
Ben