------ Register to get rid of these "In Post" ads! ------


Consider reviewing the Northwind database that comes with Access. It sounds
'Original Source: The Code Cage Forums http://www.thecodecage.com/forumz/access-tables/148846-how-make-name-table-purchase-table-join-get-data-sales.html#post542318
like you are building an order-tracking system... so you might want to look
for templates at Microsoft and other on-line sources...

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or psuedocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.

"captgnvr" <captgnvr.40s79c@thecodecage.com> wrote in message
news:captgnvr.40s79c@thecodecage.com...
>
> Dear All
>
> Thanks to this forum I have made some headway. Again I am stuck.
>
> table1 with 50 names and staff code.
>
> table2 with 100 items, price and stock.
>
> With the forum guide managed to make a table3 with one field as lookup
> field to enter names, and items.
>
> What is required is
>
> 1. an input form where, you select a name in combo box with all the
> items exhibited plus text field to enter the quantity purchased.
>
> 2. once all the quantities for the items purchased is entered against
> all the names, to make a report to show all the names and the total
> amount against their names.
>
> 3. at least give some links so that I can read and figure out.
>
> Please help.
>
> brgds/captgnvr
>
>
> --
> captgnvr
> ------------------------------------------------------------------------
> captgnvr's Profile:
> http://www.thecodecage.com/forumz/me...hp?userid=1072
> View this thread:
> how to make name table and purchase table join and get data of sales?
>