not sure if/how this requirement can be realised ?
hey folks, I'm not sure if I can put this very well in words but here goes anyway.
my goal:- to read a subset of data from up to 4 different records in Table B
then display that data (the 4 subsets) in 1 record of Table A
background:- Table A contains information about different ores
Table B contains information about different minerals that can be found in different ores
after entering all the relevant data for the ores and the minerals what I'd like to do is to be able to display the pertinent data for an ore and have the ore record present the corresponding data subsets for the respective minerals that are to be found within the ore.
hopefully, as different ore records are viewed then the different minerals and proportions will vary accordingly.
fyi:- I'm currently trialling FMP 9 and have successfully managed a 1 to 1 relationship, that's as far as I've made it atm.
many thanks for your comments, suggestions, ideas or help.