What I would like to do is make a command button in the customer database that when selected will grab the CUSID from the record the user is in, then goto the order/invoice database open a new record and fill the CUSID element so an @XLookupSourceList() can be ran to populate the available data into elements.

I know there are a number of ways to achieve this, but I am looking for thoughts / input on the best way to grab the CUSID from the one database and use it in the other in a multi user environment. Global value, Macro or ???

Thanks

Thanks Erika.