I have a table Animals with field Breed.
Breed is an integer slave id field to master Breeds table.
I use a dropdown to make users choose a breed. (ras=dutch for breed)
LookUp('[dbo].[ras]';ras_id=Parent.Default;naam) //get breed name for existing breed in table
I am not into adding records to this database from the powerapps yet but if I edit a record with no breed selected this happens:
A breed is chosen for me. It might be the first from the table or it might be the last one I used on another record.
Q1 How can be:
I inspect the value of the field in the database (parent.default) in a record with no value for breed
Since it is an integer ID field the value will probably be 0
A label with this value will not show anything. Even if I format "#.00"
A label with Empty(parent.default) will say true
A label with parent.default = 0 will say false
A label with parent.default+1 will say 1
A label with abs(parent.default) < 0.000/*..as many zero's as you like..*/0000001 will say true
Q2 What is the best way to solve the unwanted selection of the dropdown.
In the propriety software that uses the sql database I now added a breed called "-" and have this be the default. Is that really the best I can do?