Search results

  1. H

    Complex query??

    the only relationship that doesn't have a significance is the ComboID in the ProgramCodes table. again, i created this to help the user differentiate the set of codes for the combination of Body option items to the guitar. which also helps me to know which combination uses what Codes. so i...
  2. H

    Complex query??

    Hi Bob, thanks for pointing these out. 1. ok, for the FinishOptions table. the OptionCategory is a Group. The Body is the group that is being used in this db. it's the OptionItems for the OptionCategory of Body that is significant here. and a way to limit the sub form on the look-up for the...
  3. H

    Complex query??

    what are you talking about as far as i know, the db is "normalized"? telling me this does not help. IF there's a particular table that is NOT "normalized" then please tell me specifically because, again, as far as my knowledge they are. the relationships also show that. so now I am...
  4. H

    Complex query??

    Hello everyone! i hope someone can help me with either: 1. writing a query to get the results needed (will explain below) 2. write VBA to be used in query to get the results needed 3. or change table(s) to be able to obtain the data in all areas to get the results needed. The result needed...
Back
Top Bottom