Combox ID In Report - need value instead of ID

  • Thread starter Thread starter Dkline
  • Start date Start date
D

Dkline

I have a Requirements Table [tblRequirements] which lists the many
requirements needed to qualify a potential insurance purchaser. Such things
has he had his exam, did he have an EKG, etc. I set up a table to be used as
a lookup that lists the potential status in meeting each requirement. There
are five fields in the main table [tblRequirements] that use the same lookup
table.

Lookup table is a two column table with the first column being an
autonumbered field. The list in the [tlkpRequirementsStatus] is:

ID; Status
1; Ordered
2; Scheduled
3; Completed
4; Recieved
5; N/A

In the report I get the ID number. I need to get the value.

One solution would be to alter the [tlkpRequirementsStatus] by removing the
ID field. As this will shortly move to SQL Server 2000 do I need to retain
the Autonumber field?

In another thread "Display result of combo box selection on form?" it was
suggested to build a query and have each of the five [tblRequirements]
fields use a separate instance of the [tlkpRequirementsStatus]. I then
include the field from the respective instance of
[tlkpRequirementsStatus].Status and this works. Just seems like an awful
long way to go.

My question of the group is which is - is there a better way to design the
tables/queries to get the desired results in the report?

My goal is: 5 fields using the same lookup table and displaying the value in
the report, not the ID number.
 
Look at my response to the post a couple of minutes before yours from jped
"Value Of Combobox On Report".
 
I'm trying to follow the Forms model from that other thread but no joy yet.
I'm coming off of a query and have tried various flavors along the lines of:
QueryDefs!qryInsuredsRequirements!Scuba.Column(1)

[qryInsuredsRequirements] is the query
[Scuba] being the field.
 
Your combobox gets its data from qryInsuredsRequirements but your combobox
is on a form. You need to use the same syntax as in the previous post:
Forms!NameOfTheForm!NameOfTheCombobox.Column(1)
 
OK. I'll give it a go on Monday.

PC Datasheet said:
Your combobox gets its data from qryInsuredsRequirements but your combobox
is on a form. You need to use the same syntax as in the previous post:
Forms!NameOfTheForm!NameOfTheCombobox.Column(1)

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
(e-mail address removed)
www.pcdatasheet.com


Dkline said:
I'm trying to follow the Forms model from that other thread but no joy yet.
I'm coming off of a query and have tried various flavors along the lines of:
QueryDefs!qryInsuredsRequirements!Scuba.Column(1)

[qryInsuredsRequirements] is the query
[Scuba] being the field.
Click to expand...
Click to expand...
 
Back
Top