Delimited child list within parent record
Hello. I have two tables. Parent table is Manufacturer (key field is Manufacturer Name). Child table is Model (key field is Model Name). In the child table, there is a field labeled "Status" (active o...
Forum Discussion
There is a way with the IOL technique and coding to do that, but I believe it will only work on a form, and not on a report. So, in my mind its not worth doing that way, because if you have a form, you can just have an embedded report of the Active Models.
As long as the key field of the child table is numeric, such as [Record ID#] the reverse lookup will work. However, if there could be "dozens", or children models, then that would take "dozens" of loops of reverse lookups and would affect performance depending on the amount of data in the app.
As long as the key field of the child table is numeric, such as [Record ID#] the reverse lookup will work. However, if there could be "dozens", or children models, then that would take "dozens" of loops of reverse lookups and would affect performance depending on the amount of data in the app.
>There is a way with the IOL technique and coding to do that, but I believe it will only work on a form, and not on a report
Script works everywhere - it is what powers the web. This is totally possible to do with script. Script, script, script and more script.
Script works everywhere - it is what powers the web. This is totally possible to do with script. Script, script, script and more script.