Topic: Big project requires some help :)
Hi there,
I have a big project on the table and I just wonder how to figure out some specific user requirements such as the ability to choose in a list what kind of information to add in a table...
example given:
I have 10 tables, let's call them T1, T2, T3....T10.
Most of these table require separate feedings and the user would like to avoid to clutter the user interface (which is ergonomic), thus they want to see one drop list to chose which information to add and then, get the correct feeding form.
BUT....(on top of that) some information must be linked together so if one information is added in a table, I must be able to select the linked information as well. My brain is starting to hurt.
If I need to add data in T2, it must also be related to T1 and/or T3
I have attached a picture of current schema, I am looking for scripts or forms or any kind of help.