Multiple linked child/master fields on a single form

[jaydeebe]

I have a form with 3 tabs. I have made it this way so that it is easy for a user to follow the process in 3 steps. The first tab has a combo box which I would like to provide the value for a field on tab 3 automatically. The second tab already does this for a different field (by using the link master/child option) but this won't work for the first tab as the field is in another table and hence is not considered the master. How can i copy a value from a combo box in the first tab to a field in the third tab?

Jaydeebe BSC (hons) MCP

 

[lameid]

I think you are trying to ask, "how do I use an unbound combobox as the master field?"

If you build the relationship in a form for master and child fields, you only can select the actual fields in the form. However you can also enter controls manually and it will work fine.

 

[jaydeebe]

thanks for your reply, i have done it manually using Forms![mainform][combo31] as the control source of the field on tab 3.

Jaydeebe BSC (hons) MCP