A field from one table update two different fields in other table.

60 pts.
Tags:
ComboBox
forms
sub-forms
TBL_Items (ItemsID, Item) and TBL_Order (OrderID, OrderItem, DeliveredItem).

At TBL_Items it is possible to find an items that has equal funtion to other. (Item1=Item23)

A customer asks for Item1 and with a ComboBox I select Item1 and fill OrderItem.

At the moment to deliver there are not Item1 and we replace it for Item23, also we update field DeliveredItem from TBL_Items with Item23.

I would like to have a form filtered by customer with sub-forms with all the orders for that customer, I would like to perform some changes (with a ComboBox) at an Order within the subform.

Thanks and regards

 



Software/Hardware used:
Access 2007- XP Pro

Answer Wiki

Thanks. We'll let you know when a new response is added.

As I said,
To run the business, I need a form that for each customer, at the bottom of the form, has a list of orders (with a sub-form).
At the delivery moment each order has an orderitem field that has the item asked by the customer, the deliveredItem field has no item.
I would like to fill that field with an item selected from the TBL_Item by a ComboBox, to avoid misspelling

Discuss This Question: 8  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • carlosdl
    That is the description of your complete application. Could you please let the community know what exactly you need help with ? Thanks.
    69,160 pointsBadges:
    report
  • Linyera
    As I said, To run the business, I need a form that for each customer, at the bottom of the form, has a list of orders (with a sub-form). At the delivery moment each order has an orderitem field that has the item asked by the customer, the deliveredItem field has no item. I would like to fill that field with an item selected from the TBL_Item by a ComboBox, to avoid misspelling
    60 pointsBadges:
    report
  • carlosdl
    If I understand correctly, you would just need to change your deliveredItem text box to a ComboBox, and in the 'Row Source Type' property select 'Table/Query', then in the 'Row Source' property select the desired table, or build/write your query. You might want to set the 'Limit to list' property to 'Yes' also.
    69,160 pointsBadges:
    report
  • Linyera
    Carlos, Thank a lot for your answer, but it is not what I am in trouble. By the way do you speak spanish? If you do i will try to explain my problem in spanish. Regards
    60 pointsBadges:
    report
  • carlosdl
    Yes, I do. No soy un experto en Access, pero con mucho gusto intentaré ayudar.
    69,160 pointsBadges:
    report
  • Linyera
    Un gusto en conocerte y gracias El tema es que necesito diseñar un formulario que tenga como argumento de búsqueda el campo cliente, cuando la consulta encuentre el cliente buscado, despliegue en un sub-formulario la lista de todas las órdenes de ese cliente Por ejemplo Busco al cliente XXXX y obtengo un formulario: Cliente Dirección eléfono XXX dddd1234 1234567 Sub-Form Ordenes Orden item Pedido Item despachado O123 jr1234 O387 mx345 Cuando activo este formulario en el area de despacho, quiero actualizar el campo despachado con el item pedido u otro similar. Preblema: Diseñar una consulta que seleccione el cliente. Que aparezcan como un listado en un subform todas las ordenes pendientes de entrega de ese cliente. Que pueda actualizar el campo item despachado de la tabla de Items (con un comboBox) Como se ve la consulta tiene una tabla (Items) que actualiza dos campos (items pedidos e items despachados) Lo que necesito es el diseño de la consulta y del formulario con su subformulario. Mil gracias por tratar de entender el problema y tu tiempo.
    60 pointsBadges:
    report
  • carlosdl
    Bueno, lo primero que tendrías que hacer es crear las relaciones necesarias entre la tabla de las ordenes y la de los clientes (también una con la tabla de los items). Luego podrías crear una forma que muestre todas las órdenes (sin importar de qué cliente son) que se encuentran pendientes de entrega, y hacer lo que te mencionaba en uno de los comentarios arriba, para convertir el campo de item entregado en un combo box, y que muestre valores en base a la tabla de items. Después creas una forma para la tabla de los clientes, y cuando ya la tengas, desde el panel de la izquierda arrastras la forma de las ordenes hacia adentro de la forma de clientes, abajo de los campos que esa forma tenía. Si tienes las relaciones creadas entre las tablas, Access automáticamente crea la relación entre la forma y la subforma en base al cliente. En el siguiente link hay un video que explica mas o menos ésto, pero en el caso del video fue necesario establecer la relación entre la forma y la subforma manualmente. Creating a subform in Access. Espero que esto te sirva. Saludos, -CarlosDL
    69,160 pointsBadges:
    report
  • Linyera
    Gracias por tu tiempo y sugerencias. Voy a probarlo. Saludos y muchas gracias
    60 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following