Moving Proposed Items to Purchase Orders

[Randy]

Hello,

I am working on a system for bidding, making proposals, for an interior design firm. The proposal "form" has space for 45 separate items(all separate fields Qty 1, Qty 2; Desc. 1, Desc. 2; Price 1, Price 2). Depending on the clients likes and dislikes some or all of these items will be put into PO's (separate DB) for purchasing. I have limited the PO to 5 items per PO.

I am trying to eliminate the need for re-keying the item info into the PO db. This would be simple if it were a 1 to 1 transfer via a lookup. But, because I'm taking a potential list of 45 items and creating several different POs any of the bidded items could end up in any of the 5 PO fields.

I realize that this isn't very clearly stated, but any ideas are welcomed and appreciated. I am happy to supply further detail if anyone thinks it would be helpful.

Thanks,

Randy

[Randy]

Hey, I guess I stumped everyone for the most part. I don't know whether it was with my horribly difficult problem or my horribly designed layouts.

Nevertheless, my question is moot. The client doesn't really need that functionality after all. It is amazing what you learn when you sit them down and ask specific questions.

Thanks for all the reviews at least.

Randy