Adding a command button to open a form and matching keys ?

[pfiroz]

Hi,
I'm just trying to add a simple command button on a form based off of a table called tblMain. This table has a key called Entity_id. So on the form, I added a command button to open another form based on tblsupporting materials. This table also had a value called entity_id. So when I use the wizard to add the action I want with the command button, I click through and select 'form operations' and 'open form' .. then I select the form that is based on tblsupportingmaterials. The form is named frmAddSupportingMaterials. But when I get to the part where it asks me to select the field I want to link with the main form, I don't see any options for the main form. But it does give me all the variables in the frmAddSupportingMaterials. I checked the main form and it is based off tblmain so I don't know why it's not giving me an option to select Entity_id for both???

 

[Fuse3k]

Hmm, are the two entity_id's of the same data type (Number) in their respective tables? If one is a text field and the other is a number field you can't join the two.