B
BL
Hi, there,
I have my relationship built between data tables and reference table. When
I present the information on a form or subform, some data are not shown in
their "raw" state. For example, I have a period_id field in my Invoice table
and 42 means Dec 2006 by referring to the Period table.
My question is if I allow user to update the information in the form, what
is the best approach? The user does not know 41 is Nov 2006 and 43 is Jan
2007.
Indeed, I have a subform for the details of the Invoice and a lot of fields
are link to other reference tables. Thank you very much for all your kind
advise
Regards,
Barry
I have my relationship built between data tables and reference table. When
I present the information on a form or subform, some data are not shown in
their "raw" state. For example, I have a period_id field in my Invoice table
and 42 means Dec 2006 by referring to the Period table.
My question is if I allow user to update the information in the form, what
is the best approach? The user does not know 41 is Nov 2006 and 43 is Jan
2007.
Indeed, I have a subform for the details of the Invoice and a lot of fields
are link to other reference tables. Thank you very much for all your kind
advise
Regards,
Barry