Tie CustID to and Item number

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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
Mark said:
Setup:
2 tables
TbCust
Tbitem

The customer's ID are ANB, ALL, SB, FNBW, etc. The item numbers are,
Click to expand...
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
Click to expand...
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?
 
Back
Top