B
bbrazeau
I have a form based on a table(Products). One of the fields in that table is
a lookup field that looks up an autonumber field from another table
(materials).The materials table contains a field called "specific gravity".
On the form for Products there is a button that when pushed calculates a
formula(using VB code). Right now the formula is incomplete because I need to
use specific gravity from the materials table. Is there a way similar to
"Find Record" action that will get the specific gravity for the material by
looking up its Id? I think from what I've read that the find record action is
limited to records on its parent form only. I would like to do this without
resorting to making a new form that uses a querry to bring info from both
tables together. Any help would be appreciated.
a lookup field that looks up an autonumber field from another table
(materials).The materials table contains a field called "specific gravity".
On the form for Products there is a button that when pushed calculates a
formula(using VB code). Right now the formula is incomplete because I need to
use specific gravity from the materials table. Is there a way similar to
"Find Record" action that will get the specific gravity for the material by
looking up its Id? I think from what I've read that the find record action is
limited to records on its parent form only. I would like to do this without
resorting to making a new form that uses a querry to bring info from both
tables together. Any help would be appreciated.