searching form multiple Values in a Text Field

  • Thread starter Rob - IT Data Services
  • Start date
R

Rob - IT Data Services

Hi..

I have a table of Products and StateID. The products with a field for which
states they are availble using the codes from the StateID table

tbl-Products
ProductID Description Available
1 "Blue Coffee Table" "1,2,3,5"
2 "Red Coffee Table" "2,3,4,19,21,18"


tbl-StateID
StateID State Country
1 AU ACT
2 AU NSW
3 AU VIC
4 AU QLD
5 AU SA
6 AU TAS
7 AU NT
8 AU WA
9 NZ AUCKLAND
10 NZ BAY OF PLENTY
11 NZ CANTERBURY/WEST
12 NZ GISBORNE
13 NZ HAWKES BAY
14 NZ NELSON/MARLBOROGH
15 NZ NORTHLAND
16 NZ OTAGO/SOUTHLAND
17 NZ TARANAKI/WANGANUI
18 NZ WAIKATA
19 NZ WELLINGTON/MANAWA

I already have the Customers StateID figured out from the customers Country
& State. Eg Mr John Smith Vic AU = 3

How can I have a from that has a Product Selction that only shows Products
where the "3" is included in the tblProducts.Available - Note: 13 should not
be displayed..

I know the how to have a field show the list where the entire field matches
the requried Like Country = AU or State = VIC but using this normalised style
and multiple entries in the one field im a little lost.
 
S

scubadiver

Sorry if you haven't received the answer you were looking for but if you
don't design the table relations correctly you will get problems later on.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top