This I've done a thousand times, but this is new to me. I am migrating a MySQL DB to MS SQL2005. I use ESF DB Migration and all went well with the migration (done this many, many times).
So now I have the data is MS SQL and have created my Admin and Management Pages. So I've created a page that has Table A (Master with a PK) and it has children from Table B (PK: RecNo, IDX column is for the relationship). The page generates fine and when I load the page, the Master Record is listed as are It's Children. So far so good.
Now I go to security, and want to set it so that users can see/edit their OWN data. I can't select the IDX column from the Child. In fact, it is not even listed in the choices at all. I've selected the column in the SQL Editor Gui (checked the SQL as well). Also, I've made sure that I selected OUTPUT the column.
The only thing that I can see that may cause this is that the PK in Table A is a Bigint, the related columns is also a Bigint. In the past, I've used INT.
So the confusing part is that when I list the Master Records and click on the link for the Child records alll works fine, but I can't change the security settings to use the correct column from the details table.
Any Ideas???