I have two table with almost identical fields, one table has Meter details, including the meter serial number for example, I have an id field as well, which I use to link to the meter readings table. They have various fields(locations, meter types) with the same names so I use aliases. In one Table I need to give the details of the meters and in the other the meter readings, then we can start doing comparisons on the percentage of meter read during a month.
My questions is how do I link the two fields in the Multibox for selections. Hope this makes sense.
I thought of doing the screenshots, but when testing it worked actually, the situation is
1 with Township called Township, other table has Township field named MRTownship
On Selection Multibox if I select Township the selection is made on Table1 and it pulls through on Table2 as well because I linked the two table with a Meter number, it seems to work, on the meter reading side(table 2 I just have to hide records there the readingdate or period is null, so in effect hiding record where there is no meter reading