>>I'm sorry, I still don't get it. How do you know which remote view to have open, and to have bound to your fields, if you don't know what type it is until the data is entered?
>
>Fred,
>
>Your line item cursor (or view) wil be created by taking the "main' line item table and LEFT joining it to the doomahickey table on a common key. (ALWAYS surrogate keys please!) The "Doomahickey only" fields will be .NULL. for all non-doomahickey records because they will never get created unless the doomahickey code is entered in the code field.
>
>HTH,
This doesn't sound like a multi-table remote view. If it was, then adding a record would always add to both tables, not conditionally on any field. I see and understand that you're doing the with SP, but I STILL DON'T see how this could be accomplished conditionally using a multi-table remote view.
Sorry if I'm just being dense here, I haven't done a whole lot with backend data, yet, and I'm just "fact & technique gathering".