Very good work, I needed something like that. To be more precise, my sub-form will describe the various trips made by my colleagues. To do this, I'm using a textBox containing the type of trip (for example, "Trip from New York to Chicago" and "Trip on xx/xx/xxxx with xx luggage"). The WorkerXTripT table provides the nTOn link between WorkerT and TripT. As the trip information can be different, I'll use two buttons to populate the new trip record with predefined information. I'd like you to explain how to program these two buttons so that they fill the textBox of the new record. Thanks.
Hi Richard, you always show very simplistic forms that help for easy learning. Can you show how you would setup your forms if you have Example: 10 or 15 fields that will have 3 or more entries for one Customer/student/ member?
I am building a kind of MRP for my small manufacturing enterprise And I struggle with this parent-child relationship in terms of visualization on forms. When a product consists of several details and the details consist of several other details that are made from different materials. I have made like five tables to describe the relations: one for the first relation - this consist of that, second - that consist of this.. and so on. And then I do a query to make it just normal parent-child table. How would I visualize this, so I won’t miss undescribed relations and would not have to describe the described ones ( when detail which consists of some other details cold be a part of a number of different products)?
The bit where you was appending the IDS was brilliant I have had that problem couldn't work out how to do it so glad you covered it excellent video
Excellent tutorial Richard. I love learning new techniques and adapting them to my own project/s. Thank you for all you do and share with us.
Richard, great video! I definitely learned something new from this video!
Very good work, I needed something like that. To be more precise, my sub-form will describe the various trips made by my colleagues. To do this, I'm using a textBox containing the type of trip (for example, "Trip from New York to Chicago" and "Trip on xx/xx/xxxx with xx luggage"). The WorkerXTripT table provides the nTOn link between WorkerT and TripT. As the trip information can be different, I'll use two buttons to populate the new trip record with predefined information. I'd like you to explain how to program these two buttons so that they fill the textBox of the new record. Thanks.
Hi Richard, you always show very simplistic forms that help for easy learning. Can you show how you would setup your forms if you have Example: 10 or 15 fields that will have 3 or more entries for one Customer/student/ member?
I am building a kind of MRP for my small manufacturing enterprise
And I struggle with this parent-child relationship in terms of visualization on forms.
When a product consists of several details and the details consist of several other details that are made from different materials.
I have made like five tables to describe the relations: one for the first relation - this consist of that, second - that consist of this.. and so on. And then I do a query to make it just normal parent-child table.
How would I visualize this, so I won’t miss undescribed relations and would not have to describe the described ones ( when detail which consists of some other details cold be a part of a number of different products)?