June 23rd, 2013, 04:28 AM
Tables design and relationships to one table
I heard in financial systems tables design where there are many sub headers before the entries are made, the designs involve one major table for all headers maybe upto the entry level where records are assigned oarent id column and headers column. How can i do this for my own here [IMG]aasoftwares.net/zastructure.jpg[/IMG] AND how can it be Queried on a report as shown also on left side of that image.
June 23rd, 2013, 09:04 AM
June 23rd, 2013, 09:15 AM
thanks..i will check that