Thanks, Javier! I was trying to include the text values in the grid itself. Silly of me! Albert
> On Jun 4, 2017, at 3:02 PM, Javier Valencia <[email protected]> > wrote: > > Albert, > > It is pretty simple actually. Here is a form I use to edit data from the Sign > Table with lots of lookups from other tables. Having the basic record > location information on the grid allows me to quickly sort or select or the > record or records I want displayed and when a record is selected, all the > information with lookups from many tables is displayed on the right side. Of > course the form allows you to pop up list of valid codes code for the various > fields when entering data. The tabs at the top allow moving to other tables > with related sign information such as condition, reflectometer testing and > photos. Work very nicely as it becomes a complete dashboard to sign > information. > > I am sure that once you look at the form, you will get the gist of it fairly > easily. > > <image001.png> > > Javier, > > Javier Valencia, PE > O: 913-829-0888 > H: 913-397-9605 > C: 913-915-3137 > -----Original Message----- > From: [email protected] [mailto:[email protected]] On Behalf Of > Albert Berry > Sent: Saturday, June 03, 2017 11:26 AM > To: [email protected] > Subject: [RBASE-L] - Enhanced DB Grid > > 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] > <mailto:[email protected]>. > For more options, visit https://groups.google.com/d/optout > <https://groups.google.com/d/optout>. > > -- > 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] > <mailto:[email protected]>. > For more options, visit https://groups.google.com/d/optout > <https://groups.google.com/d/optout>. -- 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.
