Video instructions and help with filling out and completing Fill Form 2220 Respectively

Instructions and Help about Fill Form 2220 Respectively

The beta the database I am using is very simple all it has in it is four tables customers have orders orders have products in it but it's connected by an order details table so what is the trick we are going to use that we create a form that has the following structure it's basically very simple I say don't allow edit so I can never change this drop-down button because then I would assign a new customer to that order ID which is not good but at the moment I want to add a new order the order ID will automatically kick in because it is an auto number and then you just select the company that order that and when you do that you get automatically the information that comes with that customer and the last is a method of data entry so that is so great about this simple form it's basically a very simple form but do you have to do in order to make such a simple form you don't even need visual basic one of the tricks is that you start with putting in the order table a customer ID that is done with a lookup form and you do that by selecting here lookup wizard I did that already and then the tab lookup will have in there a combo box with a table query source type and there is a simple query behind that row I'm opening it here by clicking on the three dots and all that is in there is the customer ID and the company name in an ascending order so you get those in an ascending order alphabetically that's very important to start with so by doing that we have already that combo box that we will find later on in the form then the second step is that you create a query create and then query design and when you do that make sure that it has the following structure I did that already for you that it has the customers table and the orders table that is the information you want in your form ultimately so that determines which fields you are going to use then take the order ID from the orders table in the first field that is an auto number in the table I didn't show you that but I assume you know how to do that an auto number will automatically assign the next available number so you don't have to worry about it but it connects later on with the other tables and then in the second field you use the customer ID it would be careful that you use two custom item the orders table that is the one on the many side one customer has many orders so don't take the one on the one side and the other fields depend on what you want in your form I chose practically everything in the customers table and in the orders table that I want in here once that is done save that query and then finally we need to create that form I'm going to do that from scratch do I have one already create the form wizard and make sure that you choose from there the query that you have just created for this purpose and move all the fields in there because you have put those fields in there because you wanted them next leave it this way so don't show your data by customers just make it one long form next column not probably next give it a name I'm just going to keep orders but I have called the other one form orders and finish and that is the form you you get it has already everything in there nicely done all you have to do now is make sure that users cannot change this customer at this moment I can and that would be a disaster so I'm going to undo that so go to the design screen take the properties of the total form you can find them in that little corner there right click on it properties and under the the data tab you see you can allow additions deletions edits and filters I'm going to say don't allow edit but that would allow you to change the customer that came with that order number the lesions I leave that up to you you definitely want additions you want to get new orders so now I should be able to and to do that when I go to I cannot change this anymore but I should be able to add a new customer it will automatically number this once you select who that customer is it will automatically get an order number and all the rest of the data and it will end up all in the orders and in the order details it's a very simple trick to do this kind of tools I wish you good luck

Loading, please wait...