Hi everyone I have to solve an issue which I am having trouble to and I would like to see if any of you can help me sort this outโฆ
I have a table โFamiliasโ (families) which have a Ref Table โElementos da Familiaโ (family members) which is a part of โFamiliasโ
I then have another table called โDiligenciasโ (Diligence of services) that must refer for each family.
Nonetheless I need to relate to one or more โElementos da Familiaโ (family members). As this table is already โa part ofโ the table โFamiliasโ (Family) how can I include several family members to the diligence row?
any ideas?
โA table can only have one Ref column marked IsAPartOf (a row can only be a part of one other row).โ
Thanx, I now this and how it works.
how does your post help solve my issue? did you read all my post?
In the relationship between โDiligenciasโ and โElementos da Familiaโ you would NOT use the โIs part ofโ property.
Instead your column in the โDiligenciasโ table would need to be defined as EnumList with a base type of โRefโ and the source table set as โElementos da Familiaโ. This will allow you add one or more family members to a โDiligenciasโ row.
NOTE: In an EnumList/Ref (also Enum/Ref) type column, in order to set the source table you MUST first save the column changes once you have set EnumList and base type as Ref. Itโs an annoying bug where the source table property will not show until after an initial save.
This is something new, and I will definitely try this out!!!
I will let you know how it goes!!
John,
I tried doing exactly what you mentioned, at the beginning it seemed to work as for a minute I could list the elements inside the โElementos da Familiaโ using the methodology you mentioned.
now I dont seem to be able to get it up and running againโฆ Iโve tried several times even set up new tables and new app from scratch and it doesnโt workโฆ if some kind of bug is preventing this to list.
here are screenshots of the test app I created from scratch
Any thoughts?
For the โID Elemento Familiaโ in the โDiligenciasโ table, you need to tell it what values to show in the dropdown so youโll need to add to an expression to the Valid_If or Suggested Values properties.
If you want to be able to simply select values and not add new ones, place the below expression in the โValid_Ifโ property. To be able to add new entries from the the dropdown list, youโll want to insert the expression in the โSuggested Valuesโ property. In both cases the expression is the same.
SELECT(Elementos da Familia[ID Elemento Familia], true)
Or just:
Elementos da Familia[ID Elemento Familia]
without SELECT().
I Tried both your methods and the select method does not allow me to do a dependent dropdown that I need in this case, so I went with Steveโs method
Elementos da Familia[ID Elemento Familia]
The problem is that is listing the โID Elemento da Familiaโ code and not โApelidoโ which is the practical column for the user.
So I went back to the Familia table and set the KEY to โApelidoโ which is not optimal as it is not an UNIQUEID(), as:
Elementos da Familia[Apelido]
This way it brings the โApelidoโ which is what I need to show.
If I go back to set the KEY to [ID Elemento Familia], how can I display the name instead of the actual code?
and how can I get rid of the โDangerousโ signs?
there is probably no โandresโ as a key value in your table, it canโt ref to that string value
Thanx for your reply.
โandresโ is the row of a column [Name] which has an [ID Elemento Familia] which is KEY
Did you use a dropdown or buttons?
itโs set to AUTO
Hey @Luis_Gomes_Machado I hope youโre doing well my friend!
Hey Grant, just message you on whatsapp
@Luis_Gomes_Machado FYI, I understand part of your confusion with the dropdown being blank. I didnโt mention the below before because I was a little uncertain. But I just encountered a similar situation.
There are times when a column dropdown will automatically populate without the need of an explicit expression. Under other circumstances an expression is required to populate the desired dropdown values.
I have never investigated to understand when these two situations are expected. I have opened another post to get some clarity about this.
It doesnโt. I was just pointing out that itโs not possible to have more than one column in a table set to โIs Part Ofโ. I was trying to save you the trouble of attempting the impossible.
I think @WillowMobileSystems suggestion should work.
Thanx anyway man!!!
Thanx both Steve and John!
I was finally able to list them!
Nonetheless I encountered a problem.
any idea why the โDangerousโ signs on the options?
Yes, you most likely changed the SELECT() to return the โNomeโ column instead of the ID/Key column? REplace the โNomeโ column with the ID column and youโll be good.
REF columns MUST use the key column of the table they are referencing. This is how the link, or reference, is created that allows you access the other columns from the referenced table.
For dropdown display names, Ref columns will automatically use the Label column. In your case the Label column is already set to โNomeโ so it will automatically display that value in the dropdown for you in place of the ID value. In the data, the ID value will be stored.
I Tried both your methods and the select method does not allow me to do a dependent dropdown that I need in this case, so I went with Steveโs method
Elementos da Familia[ID Elemento Familia]
The problem is that is listing the โID Elemento da Familiaโ code and not โApelidoโ which is the practical column for the user.
So I went back to the Familia table and set the KEY to โApelidoโ which is not optimal as it is not an UNIQUEID(), as:
Elementos da Familia[Apelido]
This way it brings the โApelidoโ which is what I need to show.
If I go back to set the KEY to [ID Elemento Familia], how can I display the name instead of the actual code?
and how can I get rid of the โDangerousโ signs?
User | Count |
---|---|
32 | |
31 | |
30 | |
19 | |
16 |