In VFP 5.0, I want to create 'an updatable view' from two files (Master & Transaction). In this view, I want to retrieve a set of records from a file (Master) which are present in another file (Transaction). I'll be knowing the alias of the 'Transaction file' only at runtime. How can I do this ? Fields in Master => Item, Qoh (PrimaryKey Field => Item) Fields in Transaction => Item, QtyOut Output Fields => Master.Item, Master.Qoh