Linking two subforms in a forum??...??

[Guest]

Ok This is how I have it set-up

I have a main form that is for the invoice table
then I have a tab subform control
On the first tab is the inventory table which corresponds to the invoice.
On the second tab....... This is where I want to place the vendor table info.
The vendor table is related to the inventory table by a serial # field and
is a one to one relation but it is not related to the parent which in this
case is invoice table.

How would I get the information of the vendor subform to be populated
corresponding to the inventory field?

Thanks for yout time and help

 

[Guest]

Can anyone help or give me an alternative?

Any help is much appreciated.

 

[Larry Linson]

Just a gentle admonition. All answers here are from volunteers... even the
Microsoft personnel who reply here are doing it on their own time...
expecting an answer in an hour-and-a-half in the middle of a business day
may qualify as "somewhat impatient". For other good suggestions on effective
use of newsgroups, see the FAQ at http://www.mvps.org/access/netiquette.htm.

Now, it may be that one reason for no quick response was that to give you an
answer, people would have had to ask you for more information, to wit:

In a typical Order or Invoice, there are Detail Lines for items or products
that are included in the Order or Invoice. It would be one of these Details,
normally, that would have an entry (or could have more than one entry,
depending on the circumstances and design) in an Inventory Table.

Thus, a typical Order or Invoice Form might have a Subform containing a Form
with the Detail Lines, each of which might have a Subform with one or more
Inventory Table entries related to the item or product, each of which might
be related to a different Vendor. So, one might say that a way to handle
this is with three levels of nested Subform, or base the "Inventory Table"
entry on a Query that joins the Inventory Table and the Vendor Table.

If you will clarify what data you have, and the "business rules" for
choosing which Inventory Table entry if more than one (and you should
probably plan on there someday being more than one, even if that's not
currently the case) and, thus, which Vendor entry to choose, then someone
may be able to give you a more specific answer.

Larry Linson
Microsoft Access MVP

 

[Guest]

I am sorry. I thought the Microsoft personnel were paid for there services.
Again I am sorry and I thank any of you that take your free time to help
others including myself.

I don't believe that you understand what I am trying to do, so let me
re-explain. The following 3 tables are of importance in this situation

invoice- my companys incoivce that is created
inventory - what actually products are ordered in an invoice
vendor invoice - what the vendor sends us quarterly. (I have created this
table for the sole purpose of verifying that everything that was sent to us
really was sent)

I have a main forum with the invoice table. Then I have a tab-control with
two sub forms on it. One is the inventory table and the other is the vendor
invoice table. The only way I can link the vendor information to my actually
information(my inventory) is through the serial number. However I can't
correlate the information because they are two subforums on the same Main
forum. Is there a way around this? I was thinking that it might have
something to do with the DLookUp() command, but I am lost?

Again thanks for anyone willing to take there time to help!!!