Open a view on the different form and set the view selection depending

[AntunB]

ok i have 2 different databases

i want to add a a link in a form on database 1 that will open up a view from database 2 and change the view selection formulat to what is selected



LINK from database 1 >>>>> View from database 2 (View selection formula: SELECT field1 = variable from database1)


database 1 is a PC inventory database
database 2 is a software database

when you selct a PC from the inventory i want a link that will show all the software that is installed on that PC. This is in the 2nd database


thanks

 

[pmonett]

You cannot change a view selection formula dynamically. Since R4, you can no longer base a selection formula on a variable.

What you could do is use an Embedded view (if you are using R5 or better) in your form, check your Designer Help to see how to do that and what the advantages are.

Pascal.

 

[AntunB]

thanks for that

ill try it out