Filtering Selections

[SeanInternet]

I have 2 tables.

First table Fields:
Customer Name
Credit Card Number

Second Table:
Invoice Number
Customer Name
Credit Card Used to Pay Invoice



Let's say that in the first table, I have 3 different customers, bu
each one has 2 credit card numbers, so i have a total of 3 records.
What I would like to do in Table 2 is to add a lookup to the fiel
"CREDIT CARD USED TO PAY INVOICE". I want the dropdown box to sho
only the credit card numbers that match "Customer Name". Is tha
possible? Thanks so much for your help. An example below is listed t
make clarify my problem.

Table One Records
John Doe - 56432154654543354
John Doe - 72469445246465466
Mike Smith - 8676545646454657
Mike Smith - 6443546756564564
Joey Kahn - 65475124564646646
Joey Kahn - 45156467754654578

Table Two Records

Invoice Number: 1001, Customer Name: Mike Smith, Credit Card used t
Pay invoice: "I want the drop down box to show only Mike's CC #'s"

right now, it's showing all 6 cc #'s

 

[Van T. Dinh]

Not in the DatasheetView of the Table. In Forms, you can use a set of
cascaded ComboBoxes.

See The Access Web article:

http://www.mvps.org/access/forms/frm0028.htm