Supposing your form has a grid which displays parent and child info about the main table, e.g. INVOICE has, say, a part #, but the part desc is on the PARTS table. You want to display the part # and Part desc in the grid. A view incorporating the 2 tables would be "advantageous" here.
>is there any advantage or disadvantage to use views instead of tables in Data Environment?
>
>I think:
>advantage: in case of power failure, the tables won't corrupt
>disadvantage: in multi-users environment, the data is not real-time
>
>but I don't know if they are true.
>
>please advise
>
>regards,
>
>Jerry
- Whoever said that women are the weaker sex never tried to wrest the bedclothes off one in the middle of the night
- Worry is the interest you pay, in advance, for a loan that you may never need to take out.