Le mardi 3 avril 2007 12:MM, Ron Horsley a écrit : Ron,
> Each member's details is in a line. I need to access records quite > frequently, weekly and monthly at least to change anything and everything:, > e.g.; phone numbers; e-mail addresses, delete members; add new members; > change addresses; change subscription details which occupy 4 columns and to > get outputs. My access is required to remove existing or make up > completely new lines but mostly it involves altering the content of 1 to 4 > Fields only, and to get different outputs. OOo can handle the data fairly easily enough. The output questions will probably require some macro magic that isn't unfortunately supplied built into the product in the form of a wizard unlike Approach, a db management system that really was very intuitive. OOo Base unfortunately is not (yet anyway). > > The outputs used are in 9 types; 6 in different mini-spreadsheet layouts > from 3 to 15 different columns and all the 50+ lines; 1 form that includes > all the individual's details, i.e.,. every field in a line for 1 member at > a time; 1 that is for addressing envelopes; and 1 that will print a 3x7 > label A4 sheet of address labels. > > With Lotus Approach if any single field or line is changed on the main > worksheet or any of the 'outputs' the identical field is changed at the > same time automatically on every other one of the 9 outputs without > requiring any additional action from me. I need this from OOo. This is doable, but not easily by someone who knows nothing about programming or database languages. > > I have very little knowledge of SQL, or equal, working and do not know how > to proceed in this case. With Approach it is not necessary. That statement is oh so true :-) > > Am I asking too much from OOo at this stage in its development? Not of OOo, but probably of yourself, given what appears to be your limited knowledge of the underlying functions of a db management system. Good luck and keep at it, its certainly worth it in the long run, even if it may be hard at the beginning. Alex --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
