Reporting Out Two Names w/Phone # from the Same Table

[RichKorea]

I’m putting together a service report that will include two names with phone
numbers for contacts at the customer’s site. Service records are stored in a
ServiceReport table, and contacts are stored in a separate table, which feeds
the combo box on the input form, filtered by the customer name (there’s a lot
of repeat business and overlaps, so we want to hang on to the contacts,
rather then re-entering the data every time).

For creating a report, I’m going to need unique name and phone number fields
for ContactA and ContactB. Originally, I had the ServiceReport table just
reference the Contact_ID (autonumbered), but I modified that to have the
contact fields in ServiceReport use a combo box tied to the first column (the
ID), but displaying the second column (the name). That allows the report to
display the two names, but doesn’t let me get at the phone numbers.

What’s a good way to pull in the two names into the same report detail?

Thanks
Rich

 

[bhicks11 via AccessMonster.com]

Not sure I understand Rich but maybe it would help you to include the phone
number in the combobox query, then you can pull it from the combobox. You
may or may not have it visible.

Reference the column in the combobox like this:

Me.Lname = Me.ComboBoxID.Column(3)

Bonnie
http://www.dataplus-svc.com

 

[bhicks11 via AccessMonster.com]

Good going Rich!

Thanks for the reply Bonnie,

The combobox on the form where the data's entered already pulls in multiple
columns, I'm trying to get two references to the same Contact_Table to work
on a report. Referencing two items from the ServiceReport table to different
contact ID's wasn't working until I added a Contact_1 table and setup
separate links, but since the field names were the same, I couldn't put those
into the query.

What I just tried was creating two subforms, one for each contact category,
that queries the contact table based on the contact_ID. I then link the
subforms to the contact_ID I get back from the main report's query, and this
appears to work.

Not sure I understand Rich but maybe it would help you to include the phone
number in the combobox query, then you can pull it from the combobox. You

[quoted text clipped - 25 lines]