Master-detail Taureliusdataset

[wlandgraf (Wagner Landgraf)]

Correct, TAureliusDataset works are object level, not database level.
Thus, your class TDima doesn't have any reference to the TCommessa class. For that you should create do a bidirectional association, by adding the FCommesa field in TDima class and then modifying the ManyValuedAssociation to point to it, removing the ForeignJoinColumn attribute.

Some references:

SQL to Aurelius

In this case create a bidirectional association, adding the other side of the association in TPerPay object: [ManyValuedAssociation([], CascadeTypeAllRemoveOrphan, 'FPerPayId')] property DebItmDList: TList<TDebItmD > read FDebItmDList write FDebItmDList; as described here: http://www.tmssoftware.biz/business/aurelius/doc/web/lazy-loading_associations.html If your relation is 1-1 (which it seems from your SQL) you are all good, if not you can remove duplicates: http://www.tmssoftware.…

How to Access Parent Entity

You can't. You have to have the child entity. This is because you have to tell Aurelius that one side of the association refers to the other side of the association. You do this by using the MappedBy parameter of the ManyValuedAssociation attribute. This is explained in the ManyValuedAssociation documentation, more specifically this code snipped: Example using MappedBy parameter: TMediaFile = class private [Association([TAssociationProp.Lazy], [])] [JoinColumn('ID_ALBUM', [])] FAlbum…

Once you do that, you can set the parent object in OnNewRecord event by referencing the object, as showed here:

Link detailentity to masterentitiy OnNewRecord

Hello Jon, do this: procedure TfrmIssues.dsetIssueNewRecord(DataSet: TDataSet); begin Dataset.EntityFieldByName('studentid').AsObject := tblStudent.Current<TTblIssue>; end;