If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Choosing a package, return all items
Here I am again, still working on my shipping database. I have a need to be
able to select a package in my Order form (for example CCUSB) and have Access pull together all items that should be in that package (for example the CCUSB itself [along with it's seriel number], lead set, stress kit, cable, belt, manual, pen, and software [along with version number]) into the order and be able to list them on my packing slip too. Is this possible? Silly question. Virtually all things are possible in Access, it is just a matter of knowing how to accomplish these things. I do not possess this knowledge, so any help I could get on this issue would be greatly appreciated! Thank you very much in advance for any help. Teri. |
#2
|
|||
|
|||
Choosing a package, return all items
I assume you have a kit table that defines all the items to be included for a
package. I assume your Order Entry from is a form/subform where the order header info is in the form and the line items are in the sub form. If any of the above is incorrect, you need to change your design. There will be some details to work out, but the basic approach would be to create an parameterized append query that would gather information from your Order Header Form, your Order Detail sub form, your kit table, your inventory table, and where ever else it may need to go to get the information and append it to your order detail table. So, in the After Update event of the control where you enter the package identifier, the code would need to identify that a package code was entered, run the append query that would create the new records in the table, and requery the subform to show the newly created records. "Teri" wrote: Here I am again, still working on my shipping database. I have a need to be able to select a package in my Order form (for example CCUSB) and have Access pull together all items that should be in that package (for example the CCUSB itself [along with it's seriel number], lead set, stress kit, cable, belt, manual, pen, and software [along with version number]) into the order and be able to list them on my packing slip too. Is this possible? Silly question. Virtually all things are possible in Access, it is just a matter of knowing how to accomplish these things. I do not possess this knowledge, so any help I could get on this issue would be greatly appreciated! Thank you very much in advance for any help. Teri. |
#3
|
|||
|
|||
Choosing a package, return all items
Klatuu,
Thank you for your assumptions! I have none of those things and will remedy it right away and get moving on this issue. I will be back if I come accross problems. I will also reply again to say thank you again if I get it right the first time! Teri. "Klatuu" wrote: I assume you have a kit table that defines all the items to be included for a package. I assume your Order Entry from is a form/subform where the order header info is in the form and the line items are in the sub form. If any of the above is incorrect, you need to change your design. There will be some details to work out, but the basic approach would be to create an parameterized append query that would gather information from your Order Header Form, your Order Detail sub form, your kit table, your inventory table, and where ever else it may need to go to get the information and append it to your order detail table. So, in the After Update event of the control where you enter the package identifier, the code would need to identify that a package code was entered, run the append query that would create the new records in the table, and requery the subform to show the newly created records. "Teri" wrote: Here I am again, still working on my shipping database. I have a need to be able to select a package in my Order form (for example CCUSB) and have Access pull together all items that should be in that package (for example the CCUSB itself [along with it's seriel number], lead set, stress kit, cable, belt, manual, pen, and software [along with version number]) into the order and be able to list them on my packing slip too. Is this possible? Silly question. Virtually all things are possible in Access, it is just a matter of knowing how to accomplish these things. I do not possess this knowledge, so any help I could get on this issue would be greatly appreciated! Thank you very much in advance for any help. Teri. |
#4
|
|||
|
|||
Choosing a package, return all items
If you get it right the first time, you are way ahead of me
I don't know how far along you are in your development, but here are some basics of order entry. You need two tables Order Header - Contains information about the order, Sold to, Ship to, Date, etc. Order Detail - Related to the Order Header Table by the Order Header's primary key. Contains information on each item ordered, item number, quantity, description, price, etc. You also need access to other tables in your database. Ususally a Customer table, an inventory table, in your case, you inventory should also have a kit table that knows all the items in the inventory required to make up a "package". You need an Order form based on your Order Table. This form needs a subform based on the Order Item table. One basic mistake made in this scenerio is to have fields in your tables for the extened price for an item (quantitiy * item price), or an order total (total exteneded prices for all items + tax + shipping, etc). Don't do it! It is never a good idea nor is there ever any justification for an exception to the rule "Never carry any Calculated Value in a database". Calculate them when you need them, like on the form, the packing slip, or any reports. As to showing the extended pricing calculations on the form and sub form, look in the Order forms in the Northwind database. There is a great example there. "Teri" wrote: Klatuu, Thank you for your assumptions! I have none of those things and will remedy it right away and get moving on this issue. I will be back if I come accross problems. I will also reply again to say thank you again if I get it right the first time! Teri. "Klatuu" wrote: I assume you have a kit table that defines all the items to be included for a package. I assume your Order Entry from is a form/subform where the order header info is in the form and the line items are in the sub form. If any of the above is incorrect, you need to change your design. There will be some details to work out, but the basic approach would be to create an parameterized append query that would gather information from your Order Header Form, your Order Detail sub form, your kit table, your inventory table, and where ever else it may need to go to get the information and append it to your order detail table. So, in the After Update event of the control where you enter the package identifier, the code would need to identify that a package code was entered, run the append query that would create the new records in the table, and requery the subform to show the newly created records. "Teri" wrote: Here I am again, still working on my shipping database. I have a need to be able to select a package in my Order form (for example CCUSB) and have Access pull together all items that should be in that package (for example the CCUSB itself [along with it's seriel number], lead set, stress kit, cable, belt, manual, pen, and software [along with version number]) into the order and be able to list them on my packing slip too. Is this possible? Silly question. Virtually all things are possible in Access, it is just a matter of knowing how to accomplish these things. I do not possess this knowledge, so any help I could get on this issue would be greatly appreciated! Thank you very much in advance for any help. Teri. |
#5
|
|||
|
|||
Choosing a package, return all items
Klatuu,
Here I am again, confused. Taking it one step at a time so I don't get too confused, I need to create a "Kit" table. The table I have started includes the following: KitID, OrderDetailID, ProductID, SerielNumbersID and KitName. I believe these are the items I need, but am unsure how to link these name with the items in my Product table to pull the correct items. The kit names are also in my Product table. Do I need to take them out of there and just have them listed in my Kit table? If this is the case, I am not sure how to have them appear in the combo box in my subform to be able to choose one of them. Can you tell I am confused/frustrated? Thank you, Teri. "Teri" wrote: Klatuu, Thank you for your assumptions! I have none of those things and will remedy it right away and get moving on this issue. I will be back if I come accross problems. I will also reply again to say thank you again if I get it right the first time! Teri. "Klatuu" wrote: I assume you have a kit table that defines all the items to be included for a package. I assume your Order Entry from is a form/subform where the order header info is in the form and the line items are in the sub form. If any of the above is incorrect, you need to change your design. There will be some details to work out, but the basic approach would be to create an parameterized append query that would gather information from your Order Header Form, your Order Detail sub form, your kit table, your inventory table, and where ever else it may need to go to get the information and append it to your order detail table. So, in the After Update event of the control where you enter the package identifier, the code would need to identify that a package code was entered, run the append query that would create the new records in the table, and requery the subform to show the newly created records. "Teri" wrote: Here I am again, still working on my shipping database. I have a need to be able to select a package in my Order form (for example CCUSB) and have Access pull together all items that should be in that package (for example the CCUSB itself [along with it's seriel number], lead set, stress kit, cable, belt, manual, pen, and software [along with version number]) into the order and be able to list them on my packing slip too. Is this possible? Silly question. Virtually all things are possible in Access, it is just a matter of knowing how to accomplish these things. I do not possess this knowledge, so any help I could get on this issue would be greatly appreciated! Thank you very much in advance for any help. Teri. |
#6
|
|||
|
|||
Choosing a package, return all items
Most of what you have identified for your Kit table is not relevant.
A Kit is actually an inventory item. It should have most of the attributes of any other inventory item. Your inventory table should have a field that identifies an item as being a Kit. That way, whenever you are processing your orders and you put in an item code, you should check that field to see if it is a kit. The Kit table is used to identify all the inventory items that make up the kit. So, all you really need in that table is: Kit_ID - This would be the the primay key in the inventory table for the item that is a kit. Item_ID - The primary key in the inventory table for a component of the kit Item_Qty - The number of this inventory item required in the kit. All the other information should already be in the inventory table. It should not have any reference to the Order Detail. The Order Detail, however, should reference the Kit table. That is because Order one line item contains one inventory item and one inventory item may be ordered by multiple order line items. "Teri" wrote: Klatuu, Here I am again, confused. Taking it one step at a time so I don't get too confused, I need to create a "Kit" table. The table I have started includes the following: KitID, OrderDetailID, ProductID, SerielNumbersID and KitName. I believe these are the items I need, but am unsure how to link these name with the items in my Product table to pull the correct items. The kit names are also in my Product table. Do I need to take them out of there and just have them listed in my Kit table? If this is the case, I am not sure how to have them appear in the combo box in my subform to be able to choose one of them. Can you tell I am confused/frustrated? Thank you, Teri. "Teri" wrote: Klatuu, Thank you for your assumptions! I have none of those things and will remedy it right away and get moving on this issue. I will be back if I come accross problems. I will also reply again to say thank you again if I get it right the first time! Teri. "Klatuu" wrote: I assume you have a kit table that defines all the items to be included for a package. I assume your Order Entry from is a form/subform where the order header info is in the form and the line items are in the sub form. If any of the above is incorrect, you need to change your design. There will be some details to work out, but the basic approach would be to create an parameterized append query that would gather information from your Order Header Form, your Order Detail sub form, your kit table, your inventory table, and where ever else it may need to go to get the information and append it to your order detail table. So, in the After Update event of the control where you enter the package identifier, the code would need to identify that a package code was entered, run the append query that would create the new records in the table, and requery the subform to show the newly created records. "Teri" wrote: Here I am again, still working on my shipping database. I have a need to be able to select a package in my Order form (for example CCUSB) and have Access pull together all items that should be in that package (for example the CCUSB itself [along with it's seriel number], lead set, stress kit, cable, belt, manual, pen, and software [along with version number]) into the order and be able to list them on my packing slip too. Is this possible? Silly question. Virtually all things are possible in Access, it is just a matter of knowing how to accomplish these things. I do not possess this knowledge, so any help I could get on this issue would be greatly appreciated! Thank you very much in advance for any help. Teri. |
#7
|
|||
|
|||
Choosing a package, return all items
Okay. My kit table now includes only: KitID, ProductID, and ItemQuantity.
I am not sure I understand how this table is going to pull the items listed in the Product Table that go with each kit. I'm not sure I understand what you mean by the following: "So, all you really need in that table is: Kit_ID - This would be the the primay key in the inventory table for the item that is a kit. Item_ID - The primary key in the inventory table for a component of the kit Item_Qty - The number of this inventory item required in the kit." I know I sound like a total idiot, but I am just so frustrated with this database I can't think straight, and I need to get it done by Friday afternoon. Thanks again for your help Klatuu! Teri. "Klatuu" wrote: Most of what you have identified for your Kit table is not relevant. A Kit is actually an inventory item. It should have most of the attributes of any other inventory item. Your inventory table should have a field that identifies an item as being a Kit. That way, whenever you are processing your orders and you put in an item code, you should check that field to see if it is a kit. The Kit table is used to identify all the inventory items that make up the kit. So, all you really need in that table is: Kit_ID - This would be the the primay key in the inventory table for the item that is a kit. Item_ID - The primary key in the inventory table for a component of the kit Item_Qty - The number of this inventory item required in the kit. All the other information should already be in the inventory table. It should not have any reference to the Order Detail. The Order Detail, however, should reference the Kit table. That is because Order one line item contains one inventory item and one inventory item may be ordered by multiple order line items. "Teri" wrote: Klatuu, Here I am again, confused. Taking it one step at a time so I don't get too confused, I need to create a "Kit" table. The table I have started includes the following: KitID, OrderDetailID, ProductID, SerielNumbersID and KitName. I believe these are the items I need, but am unsure how to link these name with the items in my Product table to pull the correct items. The kit names are also in my Product table. Do I need to take them out of there and just have them listed in my Kit table? If this is the case, I am not sure how to have them appear in the combo box in my subform to be able to choose one of them. Can you tell I am confused/frustrated? Thank you, Teri. "Teri" wrote: Klatuu, Thank you for your assumptions! I have none of those things and will remedy it right away and get moving on this issue. I will be back if I come accross problems. I will also reply again to say thank you again if I get it right the first time! Teri. "Klatuu" wrote: I assume you have a kit table that defines all the items to be included for a package. I assume your Order Entry from is a form/subform where the order header info is in the form and the line items are in the sub form. If any of the above is incorrect, you need to change your design. There will be some details to work out, but the basic approach would be to create an parameterized append query that would gather information from your Order Header Form, your Order Detail sub form, your kit table, your inventory table, and where ever else it may need to go to get the information and append it to your order detail table. So, in the After Update event of the control where you enter the package identifier, the code would need to identify that a package code was entered, run the append query that would create the new records in the table, and requery the subform to show the newly created records. "Teri" wrote: Here I am again, still working on my shipping database. I have a need to be able to select a package in my Order form (for example CCUSB) and have Access pull together all items that should be in that package (for example the CCUSB itself [along with it's seriel number], lead set, stress kit, cable, belt, manual, pen, and software [along with version number]) into the order and be able to list them on my packing slip too. Is this possible? Silly question. Virtually all things are possible in Access, it is just a matter of knowing how to accomplish these things. I do not possess this knowledge, so any help I could get on this issue would be greatly appreciated! Thank you very much in advance for any help. Teri. |
#8
|
|||
|
|||
Choosing a package, return all items
Klatuu,
I don't think I mentioned the fact that pretty much any item which belongs in a certain kit may also belong in at least one other kit. I don't know if that makes a difference, but I felt the need to mention it just in case. Teri. "Teri" wrote: Okay. My kit table now includes only: KitID, ProductID, and ItemQuantity. I am not sure I understand how this table is going to pull the items listed in the Product Table that go with each kit. I'm not sure I understand what you mean by the following: "So, all you really need in that table is: Kit_ID - This would be the the primay key in the inventory table for the item that is a kit. Item_ID - The primary key in the inventory table for a component of the kit Item_Qty - The number of this inventory item required in the kit." I know I sound like a total idiot, but I am just so frustrated with this database I can't think straight, and I need to get it done by Friday afternoon. Thanks again for your help Klatuu! Teri. "Klatuu" wrote: Most of what you have identified for your Kit table is not relevant. A Kit is actually an inventory item. It should have most of the attributes of any other inventory item. Your inventory table should have a field that identifies an item as being a Kit. That way, whenever you are processing your orders and you put in an item code, you should check that field to see if it is a kit. The Kit table is used to identify all the inventory items that make up the kit. So, all you really need in that table is: Kit_ID - This would be the the primay key in the inventory table for the item that is a kit. Item_ID - The primary key in the inventory table for a component of the kit Item_Qty - The number of this inventory item required in the kit. All the other information should already be in the inventory table. It should not have any reference to the Order Detail. The Order Detail, however, should reference the Kit table. That is because Order one line item contains one inventory item and one inventory item may be ordered by multiple order line items. "Teri" wrote: Klatuu, Here I am again, confused. Taking it one step at a time so I don't get too confused, I need to create a "Kit" table. The table I have started includes the following: KitID, OrderDetailID, ProductID, SerielNumbersID and KitName. I believe these are the items I need, but am unsure how to link these name with the items in my Product table to pull the correct items. The kit names are also in my Product table. Do I need to take them out of there and just have them listed in my Kit table? If this is the case, I am not sure how to have them appear in the combo box in my subform to be able to choose one of them. Can you tell I am confused/frustrated? Thank you, Teri. "Teri" wrote: Klatuu, Thank you for your assumptions! I have none of those things and will remedy it right away and get moving on this issue. I will be back if I come accross problems. I will also reply again to say thank you again if I get it right the first time! Teri. "Klatuu" wrote: I assume you have a kit table that defines all the items to be included for a package. I assume your Order Entry from is a form/subform where the order header info is in the form and the line items are in the sub form. If any of the above is incorrect, you need to change your design. There will be some details to work out, but the basic approach would be to create an parameterized append query that would gather information from your Order Header Form, your Order Detail sub form, your kit table, your inventory table, and where ever else it may need to go to get the information and append it to your order detail table. So, in the After Update event of the control where you enter the package identifier, the code would need to identify that a package code was entered, run the append query that would create the new records in the table, and requery the subform to show the newly created records. "Teri" wrote: Here I am again, still working on my shipping database. I have a need to be able to select a package in my Order form (for example CCUSB) and have Access pull together all items that should be in that package (for example the CCUSB itself [along with it's seriel number], lead set, stress kit, cable, belt, manual, pen, and software [along with version number]) into the order and be able to list them on my packing slip too. Is this possible? Silly question. Virtually all things are possible in Access, it is just a matter of knowing how to accomplish these things. I do not possess this knowledge, so any help I could get on this issue would be greatly appreciated! Thank you very much in advance for any help. Teri. |
#9
|
|||
|
|||
Choosing a package, return all items
Which Friday in October do you plan to complete this?
If someone has given you a deadline like that, their expectations are unreasonable. From where you appear to be, even if you had MVP level skills, a complete package would take a couple of months. Now to answer your questions. The kit table is basicaly a "lookup table". It doesn't really have any information in it. It is just a way to know what makes up a kit and where to find the information on the items in the kit. Any time you are working with kits, you can use a query that joins the inventory table and the kit table using the Item_ID in the kit table and the inventory table. It is not easy to give detailed answers without a detailed question. Not a complaint, just want you to understand that if my answers seem vague, I am working with only partial information. Try this as an exercise. Create a select query as I described above. From the kit table, include Kit_ID, Item_ID, and quantity. From the inventory table, select item description and item price. In the criteria row of the Kit_ID column in the query builder put in: [Enter Kit ID] Now, run the query. When it asks for a Kit ID, give it a number that is a kit. See what you get back. "Teri" wrote: Okay. My kit table now includes only: KitID, ProductID, and ItemQuantity. I am not sure I understand how this table is going to pull the items listed in the Product Table that go with each kit. I'm not sure I understand what you mean by the following: "So, all you really need in that table is: Kit_ID - This would be the the primay key in the inventory table for the item that is a kit. Item_ID - The primary key in the inventory table for a component of the kit Item_Qty - The number of this inventory item required in the kit." I know I sound like a total idiot, but I am just so frustrated with this database I can't think straight, and I need to get it done by Friday afternoon. Thanks again for your help Klatuu! Teri. "Klatuu" wrote: Most of what you have identified for your Kit table is not relevant. A Kit is actually an inventory item. It should have most of the attributes of any other inventory item. Your inventory table should have a field that identifies an item as being a Kit. That way, whenever you are processing your orders and you put in an item code, you should check that field to see if it is a kit. The Kit table is used to identify all the inventory items that make up the kit. So, all you really need in that table is: Kit_ID - This would be the the primay key in the inventory table for the item that is a kit. Item_ID - The primary key in the inventory table for a component of the kit Item_Qty - The number of this inventory item required in the kit. All the other information should already be in the inventory table. It should not have any reference to the Order Detail. The Order Detail, however, should reference the Kit table. That is because Order one line item contains one inventory item and one inventory item may be ordered by multiple order line items. "Teri" wrote: Klatuu, Here I am again, confused. Taking it one step at a time so I don't get too confused, I need to create a "Kit" table. The table I have started includes the following: KitID, OrderDetailID, ProductID, SerielNumbersID and KitName. I believe these are the items I need, but am unsure how to link these name with the items in my Product table to pull the correct items. The kit names are also in my Product table. Do I need to take them out of there and just have them listed in my Kit table? If this is the case, I am not sure how to have them appear in the combo box in my subform to be able to choose one of them. Can you tell I am confused/frustrated? Thank you, Teri. "Teri" wrote: Klatuu, Thank you for your assumptions! I have none of those things and will remedy it right away and get moving on this issue. I will be back if I come accross problems. I will also reply again to say thank you again if I get it right the first time! Teri. "Klatuu" wrote: I assume you have a kit table that defines all the items to be included for a package. I assume your Order Entry from is a form/subform where the order header info is in the form and the line items are in the sub form. If any of the above is incorrect, you need to change your design. There will be some details to work out, but the basic approach would be to create an parameterized append query that would gather information from your Order Header Form, your Order Detail sub form, your kit table, your inventory table, and where ever else it may need to go to get the information and append it to your order detail table. So, in the After Update event of the control where you enter the package identifier, the code would need to identify that a package code was entered, run the append query that would create the new records in the table, and requery the subform to show the newly created records. "Teri" wrote: Here I am again, still working on my shipping database. I have a need to be able to select a package in my Order form (for example CCUSB) and have Access pull together all items that should be in that package (for example the CCUSB itself [along with it's seriel number], lead set, stress kit, cable, belt, manual, pen, and software [along with version number]) into the order and be able to list them on my packing slip too. Is this possible? Silly question. Virtually all things are possible in Access, it is just a matter of knowing how to accomplish these things. I do not possess this knowledge, so any help I could get on this issue would be greatly appreciated! Thank you very much in advance for any help. Teri. |
#10
|
|||
|
|||
Choosing a package, return all items
I haven't even looked at your entire response yet. I just wanted to let you
know that I was not given the deadline by anyone but myself. This Friday is my last day at this job and I really wanted to have this one done before I left. I am now going to read your response and jut set my mind to getting as much done as I can before I leave and let it go after that. Teri. "Klatuu" wrote: Which Friday in October do you plan to complete this? If someone has given you a deadline like that, their expectations are unreasonable. From where you appear to be, even if you had MVP level skills, a complete package would take a couple of months. Now to answer your questions. The kit table is basicaly a "lookup table". It doesn't really have any information in it. It is just a way to know what makes up a kit and where to find the information on the items in the kit. Any time you are working with kits, you can use a query that joins the inventory table and the kit table using the Item_ID in the kit table and the inventory table. It is not easy to give detailed answers without a detailed question. Not a complaint, just want you to understand that if my answers seem vague, I am working with only partial information. Try this as an exercise. Create a select query as I described above. From the kit table, include Kit_ID, Item_ID, and quantity. From the inventory table, select item description and item price. In the criteria row of the Kit_ID column in the query builder put in: [Enter Kit ID] Now, run the query. When it asks for a Kit ID, give it a number that is a kit. See what you get back. "Teri" wrote: Okay. My kit table now includes only: KitID, ProductID, and ItemQuantity. I am not sure I understand how this table is going to pull the items listed in the Product Table that go with each kit. I'm not sure I understand what you mean by the following: "So, all you really need in that table is: Kit_ID - This would be the the primay key in the inventory table for the item that is a kit. Item_ID - The primary key in the inventory table for a component of the kit Item_Qty - The number of this inventory item required in the kit." I know I sound like a total idiot, but I am just so frustrated with this database I can't think straight, and I need to get it done by Friday afternoon. Thanks again for your help Klatuu! Teri. "Klatuu" wrote: Most of what you have identified for your Kit table is not relevant. A Kit is actually an inventory item. It should have most of the attributes of any other inventory item. Your inventory table should have a field that identifies an item as being a Kit. That way, whenever you are processing your orders and you put in an item code, you should check that field to see if it is a kit. The Kit table is used to identify all the inventory items that make up the kit. So, all you really need in that table is: Kit_ID - This would be the the primay key in the inventory table for the item that is a kit. Item_ID - The primary key in the inventory table for a component of the kit Item_Qty - The number of this inventory item required in the kit. All the other information should already be in the inventory table. It should not have any reference to the Order Detail. The Order Detail, however, should reference the Kit table. That is because Order one line item contains one inventory item and one inventory item may be ordered by multiple order line items. "Teri" wrote: Klatuu, Here I am again, confused. Taking it one step at a time so I don't get too confused, I need to create a "Kit" table. The table I have started includes the following: KitID, OrderDetailID, ProductID, SerielNumbersID and KitName. I believe these are the items I need, but am unsure how to link these name with the items in my Product table to pull the correct items. The kit names are also in my Product table. Do I need to take them out of there and just have them listed in my Kit table? If this is the case, I am not sure how to have them appear in the combo box in my subform to be able to choose one of them. Can you tell I am confused/frustrated? Thank you, Teri. "Teri" wrote: Klatuu, Thank you for your assumptions! I have none of those things and will remedy it right away and get moving on this issue. I will be back if I come accross problems. I will also reply again to say thank you again if I get it right the first time! Teri. "Klatuu" wrote: I assume you have a kit table that defines all the items to be included for a package. I assume your Order Entry from is a form/subform where the order header info is in the form and the line items are in the sub form. If any of the above is incorrect, you need to change your design. There will be some details to work out, but the basic approach would be to create an parameterized append query that would gather information from your Order Header Form, your Order Detail sub form, your kit table, your inventory table, and where ever else it may need to go to get the information and append it to your order detail table. So, in the After Update event of the control where you enter the package identifier, the code would need to identify that a package code was entered, run the append query that would create the new records in the table, and requery the subform to show the newly created records. "Teri" wrote: Here I am again, still working on my shipping database. I have a need to be able to select a package in my Order form (for example CCUSB) and have Access pull together all items that should be in that package (for example the CCUSB itself [along with it's seriel number], lead set, stress kit, cable, belt, manual, pen, and software [along with version number]) into the order and be able to list them on my packing slip too. Is this possible? Silly question. Virtually all things are possible in Access, it is just a matter of knowing how to accomplish these things. I do not possess this knowledge, so any help I could get on this issue would be greatly appreciated! Thank you very much in advance for any help. Teri. |
|
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Choosing multiple items in a drop down list | Shad | General Discussion | 9 | July 7th, 2008 06:38 PM |
Query to Count, but return items that are null | Sandy | Running & Setting Up Queries | 7 | January 31st, 2006 07:28 PM |
recover deleted mail items | Dirty Harrhy | General Discussion | 6 | February 8th, 2005 06:09 PM |
deleted items folder | Cicero Sr in Las Vegas | General Discussion | 0 | January 26th, 2005 09:43 PM |
Tracking items sold under a sale or return scenario. | Nicholas James Pitt | Database Design | 3 | June 30th, 2004 12:48 PM |