option group in form

[mawa4492]

Hello,
I was wondering if any of you guys can help me with my form.


you can find my database attached.
When I want to create option group for "module" in I keep receiving an unidentified error.
I want it to be the way as described following:
User to add a new record, needs to pick "module", "problem" and "service" - they all are single-chosen - so I want to use option group.
Thanks in advance for your help.

[RuralGuy]

The Module field of the Module table (bad idea having a field named the same as the table) is a text field. Are you trying to put a text value other than a number in that field with an OptionGroup. I've not seen anyone do that before and I'm not sure it can be done. Rather, they bind the OptionGroup control to a NUMERIC (Integer) field and simply change the number depending on the Option selection. You can have a decode table that converts the number to a string to keep from hard coding the reference. You can then join this table whenever you want to display the string.