Hi all,
working basically on a very large document library and am figuring out design and structure before i put anything into practice. Got to break away from flat table of Excel urgently as it gets too unwieldy and slow.
IF i need a lot of linked data regarding a document - Doc name etc in 1 table, source (list of customers and agencies) in table 2, type of document in a 3rd table, content category in a 4th etc, is this the best way of structuring the database?
WOuld i be right in then creating a form which covers all linked tables to then input new information, some of which will be drawn from content listed in other tables such as categories?
Huge thanks in advance!
working basically on a very large document library and am figuring out design and structure before i put anything into practice. Got to break away from flat table of Excel urgently as it gets too unwieldy and slow.
IF i need a lot of linked data regarding a document - Doc name etc in 1 table, source (list of customers and agencies) in table 2, type of document in a 3rd table, content category in a 4th etc, is this the best way of structuring the database?
WOuld i be right in then creating a form which covers all linked tables to then input new information, some of which will be drawn from content listed in other tables such as categories?
Huge thanks in advance!