H
hughess7
Hi
I am going round and round and not getting anywhere with this...
We have a set of Issue codes, and if used, some require additional mandatory
data capturing by the end user. For example
Issue: 3100 requires text
Issue 9700 requires two dates entering
Issue: 9850 requires two times recording as n.n (double, 1 decimal)
etc etc
How would I capture this info in the correct format and store as a date or
text or number etc?
I thought about having a settings table and list all codes with the relevant
variables eg
Issue V1 V2 V3 V4 V5
3100 text1
9700 date1 date2
9850 num1 num2
etc
but how would I present the form to the user with the correct data type
controls displayed for input?
Help please!!
Thanks
Sue
I am going round and round and not getting anywhere with this...
We have a set of Issue codes, and if used, some require additional mandatory
data capturing by the end user. For example
Issue: 3100 requires text
Issue 9700 requires two dates entering
Issue: 9850 requires two times recording as n.n (double, 1 decimal)
etc etc
How would I capture this info in the correct format and store as a date or
text or number etc?
I thought about having a settings table and list all codes with the relevant
variables eg
Issue V1 V2 V3 V4 V5
3100 text1
9700 date1 date2
9850 num1 num2
etc
but how would I present the form to the user with the correct data type
controls displayed for input?
Help please!!
Thanks
Sue