>>I'm just curious...with this technique of setting relations, can you use this in a grid? I haven't ever used more than one table in a grid...
>
>Yeah, you can. I'm a little fuzzy on the details, since I only saw it and haven't tried it, but I know it can be done.
>
>The example he did was a detail list for an invoice. Instead of the part number that was part of the detail table, he had it put the description from the parts table. And if you changed the description, it actually wrote the corresponding part number into the detail table.
For simple examples (e.g. during training session :), temp relationships will show up Ok, however in real application it's invitation to troubles.
Edward Pikman
Independent Consultant