AnsweredAssumed Answered

table match (fm14)

Question asked by RoKo on Feb 21, 2016
Latest reply on Feb 22, 2016 by beverly

hi forum


in my application I have three tables

- customer

- customer-details

- questions

- answers


all tables are linked through relations (customer-details::KD_ID = customer::ID, answer::KD_ID = customer::ID, answers::Q_ID = questions::ID)

all customers must respond to all questions


in a form (selected to a customer) I will show:

a) a list with all questions

b) a list with all questions with answers of the selected customer (done)

c) a list with all questions the are unanswered


I need help for a) and c).

because of the relations I will see only the answered questions.