>> I am using method 2, but I can't get the order of the child table in the grid. RFID is the primary key in the parent table and RFID is the foreign key in the child table. How do I set the child order. The child has a compound key that is a combination of RFID (foreign key) and date. This is the order that I would like the child table to be in. I can't get the form to child records to display in the
>>My problem with parm views is that the number of views needed could grow out of control. Otherwise, I love them.
>
>I started out using tables, then went to buffered tables (optimistic row buffering) but then read an article by Drew Speedie about paramaterized views. I fell in love with them. (The optimisic row buffering kind!)
>
>The only problem I have with them is that the sql script is totally contained in the DBC, and if that gets corrupted you may loose your views. Backup - backup -backup!!!

I have had more corrupted DBCs than any other file type. Arg.