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