May 13, 200322 yr Sorry in advance. I'm new here from old DOS database. Order Form [order_main] has line detail [Order_lines] that looks up inventory based on item#'s [inventory]. Relationships [order_main & Order_lines by Order#] and [Order_lines and Inventory by Item#]. All I want is to have Order_main list 10-15 Order lines that you enter item#, it brings up description and price, you enter quantity then extensions fill and you go to next line. HOWEVER I need to be able to modify the Description that is looked up from INventory so that the modification stays with the order. I'm told don't use repeated fields, I can't get portals to list multiple lines. My text is Schwartz FM Pro 6.0 but I just can't get past this. Good help will result in increased fertility and winning lottery tickets! Jonathan
May 13, 200322 yr This post already has an answer in relationships, so ... Please remember only to post your question once; we'll find it (we also find duplicates!).
Create an account or sign in to comment