Search results

The subform is composed of table tblAlbaranFactura (tbl Dispatch note Invoice) so I have used the following links: Link Master fields: "InvoiceID; cboDispatchNoteID" Link Child Fields: "InvoiceID;DispatchNoteID" or do you think i should modify the tlbDispatchnote (TblAlbaran) adding FacturaID...

The subform is the tlbAlbaranFactura which is a table that combines both, the dispatch notes and the invoices. Here there is a pic of the relations (Sorry, its in spanish....) Pedidos are orders, PedidoDetalle is Orders Detail, Piezas are parts, Albaran is DispatchNote, Factura is Invoice)...

Dear Unlce Gizmo The invoicing system that I am developing is quite different. This is for a manufacturing company so for every dispatch note there are a number of "parts" already selected. There is not possibility that a client gets his items or parts before creating a dispatch note. The...

Hello there! I am working on a database and I bump into a huge problem. I have 2 tables: Dispatches Notes and Invoices and both are linked together in another table "tblDispatchNotesInvoice" On the form in order to develop the invoices I choose the "dispatch notes ID" using a combobox with a...

Hello Arnelgp. Sorry for replying this post so late. I have been terribly busy. Well I had some time to have a look at it. I've tried your way. I bumped into some problems maybe for my lack of knowledge. The first one was that I am only able to do it as long as the subform only displays exactly...

Hello Arnelgp. Thank you very much for your time again and for your example. I have no words to say how nice you have been and how helpful. I will try something similar to your example. I will let you know. Thank you

thank you for your answer and for your time again. I am sorry for my lack of knowledge but I am not too sure how to do that... :confused:

Thanks Arnelgp for your answer. The only thing I achieved using the child and the master link is just to display data on the subform. But what I was expecting is that I would be able from the combobox is to select the AlbaranID and with a button to add this one to the table "tblAlbaranFactura"...

This is the appearance of my database (Factura) is Invoice (Albaran) is Dispatch Note Fecha is Date Cliente is Cliente Combo box: SELECT tblAlbaran.AlbaranID, tblAlbaran.AlbaranNumero, tblAlbaran.ClienteID, tblAlbaran.Fecha, tblAlbaranFactura.FacturaID...

Hello everyone. First of all I have to say that I am quite amateur with vba. I am developing my own database and now I have bumped into a problem. I would like to use an unbound combo box to fill the fields of a sub-form using a "add bottom". The issue is that I don't know where to start, my...