Kits after the fact

[crazybake]

I setup an original DB to have four tables:

Assets, Customers, Transactions and TransactionLineItems.

(relationships: Customers:ID::Transactions::ID, Assets:ItemID::TransactionLineitems:ItemID, Transactions:TransID::TransactionLineItems:TransID).

All works fine. I am able to create a layout (setup from the Transactions table) where I can enter the customer number to create an order, I then have a portal where I enter the itemID and it will retrieve the item info (from the TransactionLineItems table). Except now they decided to kit items together. I was able to search the forum to see how kits are done, but I am missing one relationship.. I think....

I created two more tables: Kits, KitsLineItems

(relationships: Kits:KitID::KitsLineitems:KitID, Assets:ItemID::KitsLineitems:ItemID).

I am able to create a new kit and add the items. I can even go to my assets and it will tell me which kit the items is part of.(NOTE: I am lucky that each item will only be part of one kit!!)

I am missing the relationship that will allow me to use the same order layout (from the Transactions table) and instead of entering the item number in the portal, I want them to have the ability to enter a kitID instead (or better yet, both)....

[crazybake]

My posts are very confusing... I apologize, but I am stuck.

The image below shows my relationships. I just need to create the proper relationship so that:

I can create a record in the Transactions table that will allow me to enter a kitID and retrieve the kit info...