I am having a senior moment. I wish to edit data in a table of donations. In proper relational design, the parish name appears once in the table of organizations, and is identified by an ID in the donations table. The same happens for the fund name for which the donation was made.
I would like to use an Enhanced DB Grid for editing rather than a scrolling region so that he/she can sort using column headings, and use the filter bar. For the life of me I cannot figure out how to display that parish and fund names in the grid adjacent to the ID numbers, or instead of the ID numbers so that the user doesn’t need to print out the list of names to change the numbers where appropriate. Any ideas? All I can think of is creating a table with the names included when the initial search criteria are selected and loading it with the data, updating the names, allowing the user to change things as needed while editing and then updating the original donations table with the modified data. Albert -- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.

