Text box is pulling unwanted data

[hrseebeck]

I have a form based on a query that pulls quote numbers and lists what was on the quote as well as the prices. I want to add the order numbers to the quotes if the products were ordered; however, sometimes the quote is in two orders and I need to distinguish the quote between the two orders. When I enter the order number into one of the text boxes, that number fills all the other text boxes aligned to that quote number. Why can't I have different numbers in that text box?

Thank you!

 

[Pat Hartman]

The textbox must be unbound. Access keeps only one set of properties for each control in continuous or datasheet view so the only way you could see different values for each row would be to use a bound control.

 

[hrseebeck]

Thank you. I have unbound the box; however, it is still not allowing different entries. Any suggestions?

 

[Pat Hartman]

Aparantly my sentence construction was confusing. I said that based on your description, the control appears to be unbound but you need to bind the textbox so it can show a different value for each row.

 

[hrseebeck]

Thank you for the clarification. I have bound the text box by adding a field to the table; however, I am still not able to enter different numbers for one ID which is what is needed. Some quotes have multiple orders attached and I need to attach the order numbers with the quote numbers. Is this possible?

Thanks!

 

[Pat Hartman]

You can't have multiple orders in a single quote. You will need to add a new table that will serve to implement the 1-many relationship.

If you post your schema, I may be able to give you a more precise answer.

 

[hrseebeck]

Thank you for your help. It is very much appreciated. I have attached an Access 07 test database with false data for you to review. What I need is on the Customer form to be able to view the quotes attached to that customer and if the quote produced an order, enter that order and mark purchased. As stated previously some quotes have many orders; hence the problem I am encountering.

Thank you again for your help

 

[Pat Hartman]

Product number doesn't belong in the quote table. Each quote can include many products and that relationship is handled by the junction table named tblQuoteProd.

To make the form work, you need to use nested subforms. the outersubform will be for quote and it can include a left join to order which will allow you to add an order. The quote subform will be in single record view. Within the quote subform, you have a subform in continuous or datasheet view to list all the products on that quote.

Take a look at the Northwind database that ships with access to see how an order entry application works. You have an extra layer of complexity because your orders start out as quotes.