Trouble getting this basic sample set up

Trouble getting this basic sample set up

SathyaishSathyaish Posts: 1Questions: 1Answers: 0
edited August 2015 in Free community support

My tables are like so:

User
---------
Id (type string, primary key)
Professional
--------------------
Id (int, primary key)
UserId (string, foreign key references User.Id)
Field 1 (string)
Field 2 (string)
Field 3 (date time)

I am designing an HTML page to perform CRUD operations on the Professional table.

My question specifically is, what changes should I make to the editor options and the datatable options in order to:

1) Not display the Id and the UserId fields of the Professional table in the user interface;
2) But the values of these fields must be passed back and forth between the client and my ASP.NET MVC web application;
3) How do I tell editor or the datatable about the primary key and foreign key relationships so it maintains referential integrity?

This discussion has been closed.