Getting Referral name from customer table

  • Thread starter Thread starter Ramesh
  • Start date Start date
R

Ramesh

Hi,

One of the fields of the Customer table is Referral ID. When one customer A
introduces another customer B, then we put ID of A as the ReferalID in the
record of Customer B.

Now when viewing the details of Customer B, how do i display the name of
Customer A? I need to pick up the name of A from the record of Customer A
based on the ID in the record of Cust B. Getting mixed up in this.

Thanks for sorting this out ..

Ramesh
 
I have an idea that might help. I have recently created a database where
each client can know many others so I have a one-to-many relationship.

In the "many" table I have the same list of fields as in the same form and I
also use the main form as the source for the fields in the subform.

So if you put in Customer A details and then customer B details in the main
form, in the subform you can show that Customer A has referred Customer B (or
as many other referrals as you like).

Does this make sense?
 
Hi,

One of the fields of the Customer table is Referral ID. When one customer A
introduces another customer B, then we put ID of A as the ReferalID in the
record of Customer B.

Now when viewing the details of Customer B, how do i display the name of
Customer A? I need to pick up the name of A from the record of Customer A
based on the ID in the record of Cust B. Getting mixed up in this.
Click to expand...

The simplest way is to use a Form; put a Combo Box on the form bound to the
ReferalID field. Base the combo on the customer table; have the ID as the
bound column, but the customer's name as the first (or only) nonzero width
column.

John W. Vinson [MVP]
 
Back
Top