R
Rob - IT Data Services
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.
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.