Hello,
This may get posted as a different Thread name once I can figure out exactly the specifics of my question.
Here is the background. I have a product Table, and I have a Parts Table, (Both externally linked MySQL Tables) I have been using ACCESS as a front end to the database for basic data entry, but I am trying to get a little more out of the FORMS.
I created this type of form based on this Website http://articles.techrepublic.com.com...1-5285168.html at a previous position to allow for a quick way to attach items in one table to another using an intermediate link table. I found it to be a useful tool.
Here is the problem though. I now need to update the Link Table to include the QTY field of the Parts. i.e. 1 Car: 4 tires, but when I add this field, the subform does not allow for this functionality. I don't claim to understand exactly why but I believe it is because the original Design The Subform can determine the Main table FK, and based on the selection from the Combo can determine the FK of the dependent table, the Primary key of the Link table is autocomplete, but there is no way to slide the new QTY value into the mix.
So I instead was thinking after the part gets added, to throw up a Form that prompts for qty. I was looking into the FKPartID_Change() event. But the question I have is
how do i get the new PK of the newly entered record in the link table, and then what is the best method to update that record. (I do understand ADODB connections, though I am not familiar with capturing the Local connection - that I believe ACCESS has a property somewhere to capture)
So any ideas?
BTW, I have found this forum to be very helpful, and am actively reading the other threads, but it may take a few days to get an answer that way.
Thanks
Steve
( I have about 8+years as a VB6 programmer, so I understand basic VBA stuff, but I sometimes struggle with the Access API, and properties available to the