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


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.
'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#post541185

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

------ 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?
>

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


D/Jeff

Thanks for the tip. Actually I am stuck with how to make the third table using two tables as I have mentioned; one with names and their code and the other table with various items and price.

For example I make the third table using names code and products code and price, the difficulty is I do not want to put one look up field for names and one lookup field for purchase items. If I do so then I have to enter each record for a particular person and click items list and click one. Instead I want to have it in such a way, the name of the person when clicked, to appear all items and its prices and a text field to enter the quantity and another text field to show the total amount of purchase so that I can take a report print out with names and total amount for deductions in their wages.
'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#post542391

I really than you for assistance and I have been waiting for three days for some guidance.

brgds/captgnvr

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


If you are saying that you're considering using a lookup data type directly
in the table, stop now! In fact, if you are trying to do this directly in
the tables, stop sooner!!

Access tables may look like spreadsheets but they aren't. Access tables
store data, Access forms display data.

If you haven't already done so, look into how to use forms (and queries) in
Access.

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.40txx3@thecodecage.com> wrote in message
news:captgnvr.40txx3@thecodecage.com...
>
> D/Jeff
>
> Thanks for the tip. Actually I am stuck with how to make the third
> table using two tables as I have mentioned; one with names and their
> code and the other table with various items and price.
>
> For example I make the third table using names code and products code
> and price, the difficulty is I do not want to put one look up field for
> names and one lookup field for purchase items. If I do so then I have
> to enter each record for a particular person and click items list and
> click one. Instead I want to have it in such a way, the name of the
> person when clicked, to appear all items and its prices and a text field
'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#post542605
> to enter the quantity and another text field to show the total amount of
> purchase so that I can take a report print out with names and total
> amount for deductions in their wages.
>
> I really than you for assistance and I have been waiting for three days
> for some guidance.
>
> 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?
>

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


On Thu, 29 Oct 2009 18:04:18 +0000, captgnvr <captgnvr.40txx3@thecodecage.com>
wrote:

>Thanks for the tip. Actually I am stuck with how to make the third
>table using two tables as I have mentioned; one with names and their
>code and the other table with various items and price.
>
>For example I make the third table using names code and products code
>and price, the difficulty is I do not want to put one look up field for
>names and one lookup field for purchase items. If I do so then I have
>to enter each record for a particular person and click items list and
>click one. Instead I want to have it in such a way, the name of the
'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#post542815
>person when clicked, to appear all items and its prices and a text field
>to enter the quantity and another text field to show the total amount of
>purchase so that I can take a report print out with names and total
>amount for deductions in their wages.

Use a Form based on the names table, with a Subform based on the junction
table. On the subform you can have a combo box selecting the items from the
products table.

See the "Orders" form in the Northwind sample database for an exact analog of
what you're trying to do.
--

John W. Vinson [MVP]

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


D/Jeff & John

Thank you for the response. Will stop using the lookup field in the table and will read up 'orders' in Northwind.

When I am making the third table by using name field from name-table and one item field from item-table and price field, it changes the name-field name in table3.
'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#post542963

Anyhow will study more as suggested and wl get back.

brgds/captgnvr