Project has 6 lists: A,B,C,D,E,F ? ? ? **List C,D, E and F**? depend on **List B** .
? List B depends on List A items. ? When user selects an Item from List A then related ITEMS from list B are filtered and when User then selects an Item from List B then related items from List C are filtered.
TWO WAY Relation : When **user adds** item to List C then this is "connected" with related List B and List A records, with not option to relate an specific item from List C with a wrong item on lists B or A.
**Example:? **
List A Food?
List B Fruits
List C Apples if I add a new record (little green apple )on list C then by it self it should be related with Lists B and A with no option for USER to wrongly relate record.
Screen distribution for lists should fit in jut one screen.
Report: Solution must include a report which permits to filter an Item from list A and report will show related records for lists B ,C, D, E, F .