Many, Many, Many........ One? I'm lost

Here is what i am trying to accomplish (i am kinda green on access but
learning fast)

I have tool quotes i want to start using access for so i can search
history and enter old ones too.

I have a Quote that has customer and contact on it.
A single quote can have multiple tools on it (not std stock items, most
always new numbers and descriptions)
But also a single tool will have multiple quoted quantities and a price
to go with each..........

I am having a hard time normalizing this correctly, i think i might be
making everything too complex as i have been working on this on and off
for a month or two.

.

Relevant Pages

  • Re: Problem with single quote character
    ... Building dynamic SQL sometimes results in statements like ... because the quote in renders the sql ... run it through REPLACE first to change the single quote to two single ... About the only other character I can think of off the top of my head ...
    (comp.databases.oracle.misc)
  • RE: Password
    ... "Dave Hawks" wrote: ... There should be as a double quote, single quote, and space before the AND as ... Make sure that after PWORD = there is a space, single quote, and double quote. ... USERID = '" ...
    (microsoft.public.access.formscoding)
  • Re: OT: Steve Carroll begs to go to jail
    ... And yet you cannot quote a single quote of mine where I have *ever* done so. ... of harassing her any time you'd like, Snit. ... "based on sexual or lustful feelings" for you. ...
    (comp.sys.mac.advocacy)
  • RE: Password
    ... Note there are some single quote ... There should be as a double quote, single quote, and space before the AND as ... USERID = '" ... "Dave Hawks" wrote: ...
    (microsoft.public.access.formscoding)
  • Re: Problem with single quote character
    ... Brian Peasland wrote: ... Building dynamic SQL sometimes results in statements like ... because the quote in renders the sql ... run it through REPLACE first to change the single quote to two single ...
    (comp.databases.oracle.misc)