>Hello Chris,
>
>Assuming the following:
>1. You're using a view to pull the states list. If not, create one <g>
>2. There's a field in Invoices you can use to join it to the states view in assumption #1

Those are the easy parts. But I only want to join (for example) the three records in States that the user selected, not the entire list. Maybe I'm just overthinking this... Putting a WHERE Selected (=.t.) into the view clause will have VFP do the work, rather than me trying to create a new three-record cursor and do a full join.

Why is it that when things look difficult, it's always because I overlook the obvious?


>I would create an event (typically BizObjs are used to add/edit/delete records and the extra memory overhead of one may be unnecessary here) with a few public methods to do what you need. Each would then make an internal call to a private method that sets a relationship between the two views.
>