Dynamically changing a relationship?
I have a database which asks questions about some pictures stored in a table I call source data, referenced by means of a relationship on the record number.
What I would like to do is depending on a selection at startup is use one of three or four tables of pictures and questions.
Currently the pictures and questions are in a table called source data
I would like to select from Source data 1 or Source data 2 or Source data 3 etc.
I think I have to modify the relationships but I am not certain where to start.
Anybody help please.
George Humphries Filemaker novice
using Filemaker pro 10 adv and XP