This is a dilemma that i keep coming back to when structuring a database, here is the situation:
(thanks for taking the time to understand and answer my question, i tried to make it as clear as possible)
You have different types of things, types A, B, C, etc. each with its own set of attributes to keep track of, thing A doesn’t have the same set of fields as thing B for instance, and they all have its own page for entering editing & viewing.
BUT - here is the but - you still want to have all of those different types as a common list, in other words, you want entries from A B & C to be listed in a single list called D, Why? because all of those types still have something in common, for example the “Name” & “Image” fields, and you would want to display a list or have a search option for entries in A B & C together, but you dont want to have them in a single type, since they all require different attributes and User Interfaces for entering and editing.
Now, the way i do it, is have separate types A B & C, plus a type called D, and each of A B & C has its own set of fields, and D would have the “Name” and “Image” fields which is what makes them common, A B & C will have an additional field called “Name”, field type D, which will associate each entry in A B & C to a single entry in type D as a one-to-one relationship.
Before going to my question, this how i designed the “Add New” page for Type A B or C:
"Add New" page (for Type A): in addition to its own set of input fields, i add an input called 'Name", its value will be saved to the “Name” field in type A, which will automatically save it to Type D since the “Name” field in type A is an associated Field Type of D, i also add an Image input, its value will be saved to type D only.
The problem happens when designing the List/Search Page for D.
"Search Page" (for type D): you have a repeating group for type D to display all listings in type D with its Name and Images, now, when a user clicks on a listing, you want to send him to the details page with the “current cells thing”, BUT since the details page is of type either A B or C, and the current listing page is of type D, bubble wouldn’t let you send data with other types, how would you send over this data to the page?
Would really appreciate if anybody can help me out with this?