populate certain fields with same value

[orimpila]

Hello! I have db that has two hierach levels and one master unique table.
need to assign some values to every record in the following manner:
I hava a form that controls arrival date and shipment number. Then i have several other fields that are case related and contain further info, but use have the same date and shipment number.
I'd like to assing the date and s.n. values to multiple records into the master table, i.e.:
1001 1.1.2013 asd
1001 1.1.2013 ffb
1001 1.1.2013 ggh

I've succeeded to do this with linked table and a subform, but the master unique table looks like crap because it collapses the matching records as sub-recors.
Is there a way for me to assign the values without the collapse/expand format, so that it just creates new records that have same valus in the first 2 field?


Thank yoU!

[Mihail]

Me.ControlName.DefaultValue = .....

[orimpila]

there is no default value, it changes when new shipment arrives. I need to bound multiple values into one ID

[Mihail]

@orimpila "Is there a way for me to assign the values without the collapse/expand format, so that it just creates new records that have same valus in the first 2 field? " From this I understand that you wish that the new record to have two fields filled with certain data. Sorry if still I misunderstand your question.

[orimpila]

here is a picture