Hey guys! I have a question on the reference function between two tables.
In one view (weโll call it โProducts,โ) I have a referenced column where I can select a โClientโ from a drop down menu. Fantastic. But the reverse isnโt so fantastic. in the Client view, the reference showing their โproductsโ has an add โNewโ link, which goes to the product input form. I donโt want that. I would prefer the โnewโ link on the clientโs โproductsโ list to go to the table list of all products so I can select a product that is already there.
Is this a thing? Can references and reverse references both function as a dropdown selection? I donโt even know if this is a UX issue or a behavior issue or a data issue.
@Tara_Holladay ok what i would suggest you do is create a new table with the following columns: Code (UniqueID-Text), Students (Ref to your students table), Piano Pieces (Ref to your piano pieces)โฆand i personally would add in Start Date (Date- initialize to today) and EndDate(manual input or through an action button when an end date doesnโt exist). This will allow you to see for each student which pieces they have played and when and same in reverse for the pieces of music.
quick question - can one clients have many products and can one product belong to many clients - because if thatโs the case you might want to build an intermediary tableโฆ
You are requesting kind of basket functionalityโฆ am I correct?
@Segolene_Sansom Yes! Looks like Iโll be researching intermediary tables. What I actually have are a list of piano studentsโ profiles. Then I have a huge database of my sheet music and piano pieces from books. I have over a thousand โproductsโ (pieces of music for them to play) and I want to be able to assign those pieces to a studentโs profile. There will be multiple students working on the same piece on any given week, and there will be multiple pieces for each student. Maybe โreferencesโ isnโt the feature I should be using. An action maybe?
@Aleksi_Alkio That sounds promising. I donโt know what that is but I think I need to research that. I responded to another commenter in this post about what Iโm actually doing. Itโs an app to help keep my piano studentsโ weekly assignments organized.
@Segolene_Sansom Question, if I did the intermediary table like you suggested, would the end result have this possibility: Iโm in the studentโs individual profile and I can click on the name of the songs that they are working on and it takes me to that songโs individual reference page?
@Tara_Holladay yes you could.
@Segolene_Sansom Thank you!!
User | Count |
---|---|
43 | |
29 | |
25 | |
23 | |
13 |