Section Access

[apthansh]

Hi - can we do section access on 2 fileds whih are from different Tables?

Ex: Table 1

ID  State

1   CA

2   MI

3   FL

Table 2

ID       State

ABC   MI

DEF   CA

HIJ   FL

I want to apply section access based on state for each user on both the tables..there is no key b/w these 2 tables..is it doable ?

Thank YOU MUCH.

[Vegar]

If the field name is identical in both tables then you do have a "link" between the two. You just do section access as if it was a single table. 

Please remember that your section access field should have both name and field values in UPPER case. 

[apthansh]

Oops..my bad..Table 2 is as below..Field haeders are different...there is not connection b/w 2 tables..

Table 2

Name      Province

ABC          MI

DEF          CA

HIJ            FL