I am not sure I can help but tell me two things: (1) what is your match field between Table A and Table B?? [Customer ID??] (2) How is theTable A field Table A-Customer Piece Quantity defined.......jus a text field?? a calculated field??
Something to TRY...like I said no guarantees..... define the Table A field (Table A-Customer Piece Quantity) as an auto enter by calculation with the calculation being the name of the Table B field, Table B-:Piece Quantity
It might work then..............not sure.
:smileyhappy: Good Luck!
Does the following help you to see my issue any more clearly?
1) TABLE A is Raw Materials
2) TABLE B is Raw Materials Inventory
3) TABLE B, as a portal, can be seen on each Table A record via 'layout 1'
4) The relationship is: Table A, Field: RMID (auto create Raw Material ID) and Table B, Field: RMID (auto create Raw Material ID)
5) There is only one TO of Table B
6) There is only one TO of Table A
7) Table B (Raw Material Inventory) Master Layout contains these fields:
Customer Number (data exists as a result of an earlier separate portal entry)
RMINVID (auto create Raw Material Inventory ID)
Part Number (as "displayed data" from Table A Raw Materials)
Piece Quantity (data exists as a result of an earlier separate portal entry)
8) Table A (Raw Materials) Layout 1 contains these fields:
Customer Number Search (in the Header part) (text entered by user)
Customer Number (Main Body) (data exists as a result of some of the steps of the scripted FIND in the Table A) The FIND was generated on layout 1 - in the portal - and in the portal row 'customer number' field)
RMID (Main Body) (auto create Raw Material ID)
Part Number (Main Body) (text entered by user)
Customer Piece Quantity (Main Body) (This is what I want to show from Raw Materials Inventory)
I do a scripted portal FIND in the customer number field in the portal in Layout 1 in Raw Materials. The scripted find returns a found set of all Table A Raw Materials that have the same customer number as entered manually in Customer Number Search in Table A Raw Materials. Layout 1 displays the results in List Form.
Now, here is where I am stuck. I can see the RMID and the part number but I cannot see the Customer Piece Quantity that was on the same portal row that the scripted find found the 'customer number' per my manual data entry in the field 'Customer Number Search'.
Thank you for your post.
Your setup is very straight-forward. If the found set of records isn't showing anything in the portal, then the RMID in those found set of records in Raw Materials table is not found in the Raw Materials Inventory table.
In one of your found records, what is the RMID value? Now, go to the Raw Materials Inventory layout and search for that RMID value in RMINVID. Is a record found? If so, then perhaps the relationship is not set up properly. Go to Manage Database, click on the Relationship tab, and make sure the RMID field is connected to the RMINVID field. If this is correct, make sure there isn't a second field also connected. If so, then the relationship would be set up based upon BOTH fields.
Any additional information would be appreciated.