Adapters Blank Title 56862

Yahoo Archive
1
On the Salvaged Material Receipts screen, I'm trying to pull information from the PartLot table based on the PartTran.Character01 field. In the PartTran.Character01 field, the user will enter in a LotNum and I need to pull information from the PartLot table based on the PartLot.LotNum.

I have not had success at setting up a custom view (could not figure out how to link PartTran.Character01 to PartLot.LotNum). When I base the new view on PartTran, it sets the View Type to Foreign Key View and is disabled. If I could set this to subtable, then I could set up link between the tables.

I've tried custom code using the PartAdapter, but I cannot use the GetData, because I don't know the partnumber (all I know is the LotNum). I also tried the LaunchSearch and setting the SearchOptions.PreLoadSearchFilter to LotNum = 'lotnumber123'. This did not return any records, even when the lotnumber123 exists, I'm guessing it didn't work because the filter must be a field in Part table.

Any suggestions/ideas on how to pull this information from this form would be greatly appreciated.
2
Where do you locate which table an adapter searches? For example, I
have the OpMasterAdapter and it's looking for a table
called "OpMasterList," but I can't find this table anywhere? Maybe
it's a temporary table?

Thanks,

--SF