subform to get values from main form into master table

[orimpila]

Hi! I have a form, a subform and a master unique table.
I need the unique table to updated in the following manner:
Form has certain fields that need to be assigned to every record created in the subform[id] and [info1]
Subform has a unique [caseid], and contains further [info2] but needs to be bound into [id] in the main form. Example of the master unique table:
id info1 caseid info2
1 aaa 1001 asd
1 aaa 1002 dfg
2 bbb 1003 fff
3 ccc 1004 ffg
3 ccc 1005 ggh
I've managed to accomplish this with a linked table&subform structure, but the master unique table looks like crap because it collapses the subform values into sub-records in the master table when the [id] is similar. The data is in the rigth place, i just want it not to be collapsed/expanded, but every unique recors shows in the table in the regular format

 

[JHB]

I've managed to accomplish this with a linked table&subform structure, but the master unique table looks like crap because it collapses the subform values into sub-records in the master table when the [id] is similar. The data is in the rigth place, i just want it not to be collapsed/expanded, but every unique recors shows in the table in the regular format

Not sure what you mean, could you past a printscreen, (zip it)?

 

[orimpila]

can't, have less that 10 posts :/

how can i populate the master unique table so that every record created in a subform contains values set in the orignal form?
I.e main form has a field that has value aaa
i want that aaa in every record created in the subform

 

[Mihail]

Here is a link to that image, JHB. Post #5.

 

[orimpila]

yes thank you

 

[orimpila]

if i wasn't clear i try again:
I have one master unique table wich i need to populate.
I have to populate some fields with the same data ([id] and [ship no.]) that the user selects from combobox.
while thease fields are populated with the constant user selected value, i have further fields that have additional, case related info ([info1] and [info2]). This info is indexed, and i need the master unique table to contain each record.

so first the user selects the [id] and [ship no.]
[1] [1001]
then opens a subform that edits the same table. now the user creates the further info [info1] and [info2]
and does this step as many times as he has different cases.
[infoaaa][infobbb]
[infoccc][infoddd]

now i want the master table to look like this :
[1][1001][infoaaa][infobbb]
[1][1001][infoccc][infoddd]

 

[Mihail]

Maybe if you will upload the database...
You can upload anything in ZIP format.

 

[JHB]

Here is a link to that image, JHB. Post #5.

Thanks but I'm not member of that forum, and I don't like when people cross post, without telling it.
It is wast of time, if they already have got a solution.