RogueVector
New member
- Local time
- Tomorrow, 06:49
- Joined
- Feb 17, 2013
- Messages
- 6
[Access 2007]
Alrighty, gents, thanks in advance for helping me with this problem as I do believe its a little tricky:
I have a table "Items" with a text field (DeliveryCode) that is linked in a many-to-one relationship with a table of DeliveryCodes (the only column, as the primary key).
The Items field contains information on each item we had/have in inventory. (Item ID, width, height, thick etc.).
I have a form (frmDeliveryList) that navigates by the Delivery Code table with Record Source "SELECT Delivery.DeliveryCodes FROM Delivery;" that works just fine in finding all items that have the selected DeliveryCode and displaying them in the subform inside of frmDeliveryList (Master and Child fields are linked).
The subform itself has a combobox that lists all unsent items (SELECT Items.ItemID, Items.Sent FROM Items WHERE ((Items.Sent) = "No"); as well as text boxes for displaying the rest of the relevant information. That all works perfectly fine in helping autocomplete the item ID when typing in a new one.
There is a query (qryDelivery) to find all records in the Items table that has a delivery code matching that of the one selected by the frmDeliveryList.
qryDelivery has an INNER JOIN (FROM Deliveries to Items) for Deliveries.DeliveryCode = Items.DeliveryCode.
What I want the subform to do is have it so that when I enter a new ItemID in the subform, it will automatically pull the rest of the information on the item from its table rather than think its a new item.
Alrighty, gents, thanks in advance for helping me with this problem as I do believe its a little tricky:
I have a table "Items" with a text field (DeliveryCode) that is linked in a many-to-one relationship with a table of DeliveryCodes (the only column, as the primary key).
The Items field contains information on each item we had/have in inventory. (Item ID, width, height, thick etc.).
I have a form (frmDeliveryList) that navigates by the Delivery Code table with Record Source "SELECT Delivery.DeliveryCodes FROM Delivery;" that works just fine in finding all items that have the selected DeliveryCode and displaying them in the subform inside of frmDeliveryList (Master and Child fields are linked).
The subform itself has a combobox that lists all unsent items (SELECT Items.ItemID, Items.Sent FROM Items WHERE ((Items.Sent) = "No"); as well as text boxes for displaying the rest of the relevant information. That all works perfectly fine in helping autocomplete the item ID when typing in a new one.
There is a query (qryDelivery) to find all records in the Items table that has a delivery code matching that of the one selected by the frmDeliveryList.
qryDelivery has an INNER JOIN (FROM Deliveries to Items) for Deliveries.DeliveryCode = Items.DeliveryCode.
What I want the subform to do is have it so that when I enter a new ItemID in the subform, it will automatically pull the rest of the information on the item from its table rather than think its a new item.