Linking Parent ID Autonumber with subform

[banpreet]

Hello guys,



I have a form that generates a master ID (text), then gets carried onto another form, with another id which is parent to the master (autonumber). This parent id is called TR_ID. There will be many ids associated to the master id when searching. Now I have three subforms on this form. I made the id same as the parent id, called it TR_ID on each subform so I can link to the parent ID. Problem is I made TR_ID the parent ID on the subform and linked it with the child ID which is TR_ID on the subform. However when putting information, I just made the subform and the parent ID is on record 59, and when I put information in the subform, in the table the TR_Id gets stored as 1 then 2, then 3, and so on since its autonumber. It won't match with the parent TR_Id 59 or whatever number it will be on. Should I just link the child ID with the master ID on the form? Thanks, all help appreciated!

[jwhite]

Pardon me if I read to quickly, but the Master Link should be the Control on the Main Form, and the Child Link should be the Control on the Sub Form.

[orange]

See if this free video on Form/subform helps

[trident]

Banpreet,

here is what I do.

SAMPLE
Main Table Child Table

MainTAutoNumber ChildAutoNumber
Name ChildTLink - you should link this to the MainTAutonumber
year Course
age Section

When creating a form, use the subreport form wizard and you have to connect the MainTAutoNumber with ChildTLink.

If done correctly, you will be able to populate the Maint Table and Child Table with only the right information required.

Trident

[John_G]

On the subforms, the parent_id that refers back to the main form (and links to it) cannot be an autonumber. It has to be the same type as the field in the main form.

That does not mean that the subform records cannot have their own autonumber - in fact they probably should to establish unique ID's.

It's perfectly OK to have three subforms each referring to (linking to) the same field on the main form, and there is no requirement that the field or control names be the same - it's the links that are important.

[banpreet]

I got it to work, I had to switch the data type to number! Thanks guys it was an easy solution just don't know why it was that hard to figure out.