utterly and completely stumped, flummoxed, frustrated- got a valium?????

[Gina]

Our company sells a product to multiple customers (some of
which are affiliated with each other).
As part of our overall implementation of our product, we
need to identify the people at our customers who fill 27
different roles.
One person may fill multiple roles at multiple customers.

I have developed the following relationships:

Customer/Role Table, where customer/role is the primary
key. This table populates by means of a cartesian effect
between customer and role source tables, and is appended
with new records (for instance when a new customer is
added) by means of an append query.

Contact Table, where there is a typical autonumber primary
key.

These two tables are joined by means of a
Contact/Customer/Role table, which has two fields. The
first is a lookup to Customer/Role, the second is a lookup
to the Contact.

I have a tabbed-form that lists scads of customer data,
and filter that form for each customer by means of a drop-
down box that filters.

Here are the problems I'm having:

1. I've created a subform in the customer tab that shows
a query I created that shows each contact for the
customer/role, as well as the nulls. When the user does a
lookup from the down-arrow, they can see all of the
customer data, but once selected all they see is the
number. This is freaking out a lot of the users. They
want to be able to see the First-Last name there and not
the primary key number.

2. On the tabbed form, after you have filtered the form
for a specific customer, it filters the record as it
should to show just the fields for that customer... but if
you accidently roll the mouse wheel, it jumps to the next
customer. How do you stop that?

Please help.

Thanks,
Gina

 

[Guest]

Gina,
1) You can have your combo box to have the first column with a width of 0".
Make sure your bound column is still column 1 (or whatever your id number
is). Then the user will see the name but the value in the field will be the
ID number.

2) You need to base your subform on your tab to be off a query that is
limited to that customer. That way, it will only show that customer info and
if the wheel is scrolled, a blank record. If you have the property set to No
Additions, then you won't see the blank record but you won't be able to add
either, depends on the purpose of this form.

Hope this helps.