Probelm listing products that are only availble in certain locatio

[Guest]

Hi..

I think I might be going around this the wrong way - but this is where Im
at..

I have 2 tables of tbl-Products and tbl-StateID.
The products has a field which lists states they are availble using the
[StateID] from the tbl-StateID

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

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

The StateID is to be compared to the equivalent ID from the State & Country
of the customers details. 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: products that
have a 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.

 

[John W. Vinson]

I think I might be going around this the wrong way

You are.

- but this is where Im at..

Answered in m.p.a.queries. Please don't post the same question in multiple
newsgroups; instead, if you must, crosspost to two or three (at the very most)
groups. It's a waste of the volunteer's time to answer a question in one group
only to find that it has been answered already elsewhere, and a waste of your
time to look in two or three groups for the answer.

John W. Vinson [MVP]