how to make name table and purchase table join and get data of sales?

[captgnvr]

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 looku
field to enter names, and items.

What is required is

1. an input form where, you select a name in combo box with all th
items exhibited plus text field to enter the quantity purchased.

2. once all the quantities for the items purchased is entered agains
all the names, to make a report to show all the names and the tota
amount against their names.

3. at least give some links so that I can read and figure out.

Please help.

brgds/captgnv

 

[Jeff Boyce]

Consider reviewing the Northwind database that comes with Access. It sounds
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]

D/Jeff

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

For example I make the third table using names code and products cod
and price, the difficulty is I do not want to put one look up field fo
names and one lookup field for purchase items. If I do so then I hav
to enter each record for a particular person and click items list an
click one. Instead I want to have it in such a way, the name of th
person when clicked, to appear all items and its prices and a text fiel
to enter the quantity and another text field to show the total amount o
purchase so that I can take a report print out with names and tota
amount for deductions in their wages.

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

brgds/captgnv

 

[Jeff Boyce]

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.

 

[John W. Vinson]

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.

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.

 

[captgnvr]

D/Jeff & John

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

When I am making the third table by using name field from name-tabl
and one item field from item-table and price field, it changes th
name-field name in table3.

Anyhow will study more as suggested and wl get back.

brgds/captgnv