How to reference a Table that is not using REF type?

[Firstuser]

Hi,

I am trying to figure out how I can create a connection between 3 tables that are not using REF type. I have Peer nomination view where users can nominate their peer. once nominated, the user that got nominated will go to a view where he/she can approve ( Need to approve before he/she can rate) once approved, the rater will have a page where there is a action button that uses LINKTOFORM to go to the Peer Evaluation form to submit. Things I need to do:

1. Need to hide the evaluation button after the rater submits a evaluation. Currently the button will stay appear since my formula only makes it to show to the accepted peer raters. below is my expression:

OR(
AND([Email Address of Employee (Peer Rater 1)] = useremail(), [Status for Peer Rater 1] = “Accepted”),
AND([Email Address of Employee (Peer Rater 2)] = useremail(), [Status for Peer Rater 2] = “Accepted”),
AND([Email Address of Employee (Peer Rater 3)] = useremail(), [Status for Peer Rater 3] = “Accepted”),
AND([Email Address of Employee (Peer Rater 4)] = useremail(), [Status for Peer Rater 4] = “Accepted”)
)

2. I need a view for the rater of all finished rates that they have done.

3. I need to show a separate table for the rater to see all of the achievements of the ratee, but that is on another table.

Thanks for helping

[Marc_Dillon]

Why are you not using REFs? Sounds to me like you’re doing something in a very poorly designed/structured way. Especially from that expression you’ve shown, having multiple pairs of columns for the same thing, that should probably be a separate table. Can you show more of your setup, like the data tables?

[Firstuser]

Hi Marc,

Thanks for the reply, I have a separate tables for each categories of the user.so I have category 1 -9. in each category, there are forms. Goal accomplishment which users will fill out, one is peer nomination which user will fill out and one is supervisor evaluation which the supervisors will fillout and a rater evaluation which the nominated rater will see all of the users that he/she needs to evaluate.

I have a main data where all of the employee and their direct supervisors. So all of it has a different table. total of 70 data tables.