Tie CustID to and Item number

[Guest]

Setup
2 table
TbCus
Tbite

The customer’s ID are ANB, ALL, SB, FNBW, etc. The item numbers are, ANB1000, ALL1000. SB2000, and FNBW1001, etc. All item numbers are unique but have the customer’s id leading it

The question is: On a form I will select the customer ID. How would I make it only show me the items that match the customer id in a combo box? Meaning ANB would find all items with the leading ID, plus the number?

ANB Find
ANB1000, ANB2000, ANB200
No
ALL1000, SB100

Thanks all, your great help

 

[Adrian Jansen]

Easiest to have the tblItems table hold the Customer ID and item number as
two separate fields. Then you can filter on the CustomerID directly. When
you want to show the combined item nunber, use a query calculated field to
combine the two fields:

FullItem: CustomerID & ItemNo

--
Regards,

Adrian Jansen
J & K MicroSystems
Microcomputer solutions for industrial control

Setup:
2 tables
TbCust
Tbitem

The customer's ID are ANB, ALL, SB, FNBW, etc. The item numbers are,

ANB1000, ALL1000. SB2000, and FNBW1001, etc. All item numbers are unique
but have the customer's id leading it.

The question is: On a form I will select the customer ID. How would I

make it only show me the items that match the customer id in a combo box?
Meaning ANB would find all items with the leading ID, plus the number?