Decisions about db setup...

Tech-Archive recommends: Fix windows errors by optimizing your registry

Hello everyone thanks for reading my first post.

I recently started a new job and would like to wow the boss but I need a
little help. What I am trying to create is a db with customer orders in it.
I have 3 tables so far one being a subform and is as follows:

-Customer order
-Parts detail (subform of main order)
-Customer Information

I am just getting wet behind the ears and have purchased an access 2003 book
but sometimes it's better to get the db right by asking. I'm more of a learn
by doing and would love to know what to "do" haha. Anyways.... I want a form
where you input the order and select the customer this draws the customer
info from another table and when I create my report displays it on the tip
with the parts list details. I have tried to go into expression builder and
put = the table name and the field but it just displays #Error. I thought
things weren't linked right..... i don't know i've spent quite a few hours on
this db already. I just need this problem solved first and foremost. thanks
guys :)

.

Relevant Pages

  • Re: Need help setting up a Parent form with three subforms
    ... (customer name, customer address). ... One parent form that contains customers' addresses and contact info ... One subform that contains the Quote Details ...
    (microsoft.public.access.forms)
  • RE: Subforms and Many-to-Many relationships
    ... Products and the "Committed Funds" field. ... get the product description to appear on the subform. ... Your main form Customer should be a bound form (i.e. it is linked to the ... customer is committing to the product ...
    (microsoft.public.access.formscoding)
  • Re: OT - Obnoxious customers & limits
    ... moment about ordering wine, and since I know more about the wine in the store, I take him up to the computer/register to take the order. ... I smiled at him while he went into this long tirade, the upshot of which was that the boss KNOWS he wants the wine since he orders a case every month, KNOWS his name and that he doesn't have to put up with this, if he has to he'll order somewhere else. ... When the boss got back, I gave him what part of the order I was able to take, mentioned how unpleasant the customer was, and learned that this is NOT a standing monthly order. ... State employment offices investigators/personnel typically take a dim view of an employer letting their employees be badgered and/or berated, especially if it is just for a sale of merchandise. ...
    (rec.food.cooking)
  • Re: data not flowing properly
    ... Create a continuous subform based on the Order Details. ... Customer: Customer ID, Customer Name, Customer Name Detail, Customer ... Order Detail: Sales Order Number, Skids/Parts Number, Skid Quantity, ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Subforms....Advise Please...........
    ... You might like to try the tab control, ... The only issue is that the user can't see which customer this is when they are on a secondary tab page. ... info subform in it and create two separate data entry forms for the other two ... >> The normal usage is 2 tables with a one-to-many relation, such as>> Invoice ...
    (microsoft.public.access.forms)