I have a heck of a time getting my mind around this relationship, fumbling around every time with it.
In the Parent Table – Resets, I use a text-formula field in the Resets Table to create the ResetID#, this ResetID# is then passed to the Child Table – Travel, when a new travel record is created for a given reset. A reset can have one travel record or innumerable travels.
Now what I want to do is reverse the order, where the Travel becomes the Parent Table and Resets becomes the Child Table. What I need is to pull back to the Reset Table the associate that is the assigned Lead for a Reset (Reset Lead). Of course, the common denominator is the ResetID# in both tables. The ResetID# is not the key field in either table. So, how can I make this field a relate-able field in both tables?
Work # is 770-840-1840
Hans J Hamm
O: 770 840-1840
This e-mail message, including any attachments, is for the sole use of the intended recipient(s) and may contain information that is confidential and protected by law from unauthorized disclosure. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.