hi guys woner if anyone can help me, i wish to have a field in view for create a list of data across seveal differing fields of data collected.
basically i have a database spanning several sperate tables will all the data assisned to a specific user id. on "form 4" in the first field i want a list to pick from that consists of data entered into specific fields for this users id in forms 1,2 and 3 before it.

any help would be much apprechiated many thanks all