C
Cheech73
The DB does contact management / leads fulfillment for a magazine. I have
numerous demographic fields on a form (combo boxes) that pull from an equal
number of tables that store reader service information.
Here's a brief i.e. from one of those relationships-
Table: ProjectStart
Fields: ProjStartID as Autonumber, and ProjectStart as text
The data in ProjectStart allows form users to select when a reader's project
will start... 0-6 months, 7-12 months, 1-2 years, 2-3 years.
Here's the problem. On my form, when you select any of the above "answers",
they appear correctly on the form. In my table, and subsequently, on my
reports, I only get the Autonumber data - "1" for 0-6 months, "2" for 7-12...
etc...
Seems like an easy thing to fix but I don't know where to look.
Thanks all.
-Frank
numerous demographic fields on a form (combo boxes) that pull from an equal
number of tables that store reader service information.
Here's a brief i.e. from one of those relationships-
Table: ProjectStart
Fields: ProjStartID as Autonumber, and ProjectStart as text
The data in ProjectStart allows form users to select when a reader's project
will start... 0-6 months, 7-12 months, 1-2 years, 2-3 years.
Here's the problem. On my form, when you select any of the above "answers",
they appear correctly on the form. In my table, and subsequently, on my
reports, I only get the Autonumber data - "1" for 0-6 months, "2" for 7-12...
etc...
Seems like an easy thing to fix but I don't know where to look.
Thanks all.
-Frank