affect same data in column at linked two Table

[mhakim]

hi dears
good day

i have table Header and Cloumn called Branch_id
and
i have table Details and Cloumn Called Branch_id

form like Invoice Headers and Details

i use one form to insert data to Header & Details (Header one record primary key and Details many records as Subform forein key) primary key is different or it is not Branch_id

so i need to chose Branch_id in form in Header Part and then it will affect Branch_id in subform Details with same value with out manual chose Branch_id again in the Subform

 

[Edgar_]

If form has subform, choose subform > in properties pane choose data > link master and child forms > click ellipsis (the dots) choose Branch_id in both and it will link the forms

So if you change record in form, you will see children to that record only in subform

 

[mhakim]

If form has subform, choose subform > in properties pane choose data > link master and child forms > click ellipsis (the dots) choose Branch_id in both and it will link the forms

So if you change record in form, you will see children to that record only in subform

very good
thanks

but
i already have two mandatory fields Linked
so how can i manage another two fields

 

[CJ_London]

You can use multiple fields- just separate with a semi colon

linkmaster - field1;field2
Linkchild- field1;field2

 

[mhakim]

You can use multiple fields- just separate with a semi colon

linkmaster - field1;field2
Linkchild- field1;field2

very good
i like this

 

[mike60smart]

It might help if you upload a copy of the database.