jtwilber Posted May 13, 2003 Posted May 13, 2003 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
cjaeger Posted May 13, 2003 Posted May 13, 2003 well, you can have -editable - descriptions with portals if you choose "lookup" in auto-enter options for your Order_lines instead of a caculation....
paulage77 Posted May 20, 2003 Posted May 20, 2003 Make sure your portal is set to display more than one line. Double click on it in Layout View and see what the Lines To Displa box says. Also, make sure the fields you have put into the portal are actually within the boundry of the portal. I have "missed" the portal before or accidentally moved them off a little bit, at that point you will only see one line of related info.
Recommended Posts
This topic is 7927 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now