Azure, without primary key in child table not possible to add data

[jwi]

Hi,

I am a beginner to powerapps and ssms, hopefully someone can help me 

If I do not add a primary key to my child table in ssms, the "plus" data icon is not visible:

However, when I add a primay key, the 'plus' icon is visible.

As I do not want to add data to the primay key field (which is now mandatory), what do I have to do?

Thanks a lot for your answer!

John

[timl · Accepted solution]

Hi John,

For the SQL Server connector to connect to a table, it is a mandatory requirement for the table to have a primary key.

If it's just the case that you don't want the user to enter a primary key value in your form, you can an int column to your table and set the Identity property to true. This will create a server generated, auto-incrementing primary key value in your table.

[jwi]

Good day, thanks for your advise!

Works perfect.

John