Problem about Multiple Data retrieve to a form from a table.

[tinyappz]

Problem about Multiple Data retrieve to a form from a table. look at the image attached
There is a table called products from that i wanna get data when i select the drop down arrow as in the attached image, when selecting a PRO_Code in drop down there are products as RSK60, RSK41 etc you can see. when selecting the products other Fields(Pro_Description) will fill automatically .
Question is when we select the second product and change the value to as example RSK41, first product also change to RSK41 instead of RSK60. What i have done is in combo box properties , Data then Control source as PRO_Code from the table. There is an image also for each product as you can see.Here i have attched the databse that used to retrieve data to form.
how to avoid this waiting for expert opinions .

[June7]

The ControlSource is wrong. What table is the form bound to (Product Details)? What field in that table should the PRO_CODE be saved in? Bind combobox to that field.

[tinyappz]

Thank you for the reply.
Table from bound to PRODUCT MASTER
Yes that is saved in PRO-Code , also we have bind that see the image.
This is done by Access 2003





added the DB file here

The ControlSource is wrong. What table is the form bound to (Product Details)? What field in that table should the PRO_CODE be saved in? Bind combobox to that field.

[June7]

Ooops, the form design is wrong. You have 3 sets of controls all bound to the same fields. Of course they will all show the same info, they are all editing the same record. Remove the 2 duplicate 'rows' of controls.

Show your table structure, not the queries.

[tinyappz]

Ooops, the form design is wrong. You have 3 sets of controls all bound to the same fields. Of course they will all show the same info, they are all editing the same record. Remove the 2 duplicate 'rows' of controls.

Show your table structure, not the queries.

Remove the 2 duplicate 'rows' of controls.

Show your table structure, not the queries.

Since i am Novice Above 2 things not clear for me , really appreciate explanation further .

[June7]

You have 3 rows of controls on the form: PRO_CODE PRO_DESCRIPTION GARMENT etc

Delete 2 of them.

The posted image shows a list of queries in your db. An image of table structures would be more useful. I just noticed the link for database but I can't open rar files. Windows Compression zip only.

[tinyappz]

I think there is misunderstanding ,
Here is what this MS access for ,
Main thing is to print a invoice as attached here ..
6 products(RSK 61, RSK 45 etc) needs to print in 1A pager. there are separate forms for adding products , adding customers, Order transaction form for generating invoice . in order transaction form we need to add up to 6 product at the moment we have place 3 as you can see in above posts.
So we can't remove duplicate rows , as i think .
Really appreciate your response .

[tinyappz]

Here is the table structures


and access zip file here.

[June7]

You have to remove the duplicate rows because they won't do what you want. As I said, all three rows show the SAME RECORD. PRO_CODE and CUS_CODE textboxes should be bound to the fields from TRANSACTION_TAB.

If you want to use this form for data entry, the query join types cannot be INNER. Click on the lines linking tables and change the join to: "Include all records from Transaction_Tab and only those from ..."

Change the form to Continuous View.

Forms are intended for data entry/edit and screen display. Reports are best for printing.

[tinyappz]

after remove 2 rows how to add products up 6 to the form for making an invoice ?

[June7]

Click the intrinsic 'new record' button at bottom of form or create a custom button to move to new record.

Or change the form to Continuous view to see multiple records at once, like a datasheet.

Add as many records as you want.

[tinyappz]

how can i add up to 6 products to under one invoice ? invoice should generate up to 6 products per 1 invoice no..i have change setting as mentioned above.

[June7]

Probably should have two tables.

tblInvoices
InvoiceNum (primary key)
InvoiceDate
CustomerID

tblInvoiceDetails
InvoiceNum (foreign key)
ProductID
Quantity
Size
Price

Use form/subform arrangement for data entry. http://office.microsoft.com/en-us/ac...010098674.aspx

[tinyappz]

I have done as you mentioned above. and made tblInvoiceDetails as sub and as main tblInvoices, but there is small problem of adding product and moving to next record, when moving to next record sub forms not clear the previous data we entered. what we can do for that.

[June7]

Did you actually bind the forms to the tables? Did you set the subform container control Master/Child links properties?

How are you moving to next record?