Duplicate columns using associations

[wlandgraf (Wagner Landgraf)]

@Gabriele_Dunkel

Do I have to remove the field Fsmg_basis_group_id

Yes. Associations should only be defined using properties of type object.

@Gabriele_Dunkel

But how can I use it without using (and loading) the complete basis_group?

You don't. You should always use the associated object. Here are some topics I gathered for you for better understanding of the mechanism:

Setting Parent ID (foreign key value) directly

Correct, the parent is already in the manager and that's the best way to do, as it won't execute any SQL but retrieve from cache. You can also create the Parent object in advance and add it to the manager before making the Find calls: Parent := TParent.Create; Parent.Id := ParentID; ObjMgr.Update(Parent); But note that you have to be sure that the Parent object will never be flushed, otherwise the record in the database will be updated and the missing properties will be set to null.

Crash Course TMS Aurelius - Associations (Foreign Keys)