RE: Need Help with Creating a Database

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

You've posted this same question to 4 different groups. It is rarely
necessary to post to multiple groups, but if you do you should
cross post by selecting multiple groups at the same time. That way,
an answer in one group shows up in all groups that the question was
posted to. Then you don't have multiple responders repeating the
same efforts. The people that respond here are volunteering their time.

--
_________

Sean Bailey


"Gunnu" wrote:

Hello,
I am trying to create a database using access. I want to store the
current inventory of boxes and other moving supplies. When i sell an
item from this inventory to a customer, i want to store that
transaction and reduce that item in the inventory. How can i do this?
I am confused in setting up the relationships between the tables. I
know that i would need these table:
(1). Customer table
(2). Order table
(3). Product table
But how do i represent, for example, " A customer purchases many
products in one order" and how do i decrease those items quantity in
the product table.
Thanks,
Bharath

.

Relevant Pages

  • Re: Changing Security
    ... The section you need to look at is "Enable Mixed Mode Authentication After ... Please do not cross post to multiple groups. ... Mandar Naik ...
    (microsoft.public.sqlserver.security)
  • Re: Simple Query Question
    ... You posted this question in the Queries newsgroup at 4:13 PM PST. ... with that thread, rather than cross post. ... It's okay to multipost, when appropriate, but cross posting should be ... (separate posts of the same content to multiple groups) ...
    (microsoft.public.access.gettingstarted)
  • Re: Kaspersky Security Suite v6
    ... On Fri, 13 Oct 2006 01:11:52 GMT, G Mulcaster ... Where are his multi-posts? ... multiple groups so I should see only 1 message in the first group ... I see both of his posts because he didn't cross post. ...
    (alt.comp.anti-virus)
  • Re: How to total cells in a range with data input
    ... it's better to cross post one question for ... than to post multiple same questions to multiple groups ... Data is only input in a few cells. ... Or does it> involve some behind the scene VBA programming? ...
    (microsoft.public.excel.misc)
  • What is svchost.exe?
    ... do not post the same question in multiple groups, ... cross post this makes answering your questions and see how ... "Long time listner, first time caller." ...
    (microsoft.public.windowsxp.general)