I have three tables titled:
Goods
GoodsAdd
GoodsProfile
The Goods table contains the required data including a primary key which is joined to the GoodsAdd table on a foriegn key. This creates a one to many join. Goods on the one side and GoodsAdd on the many side.
There are three forms based on three queries qryGoods, qryGoodsAdd, and qr7GoodsProfile. From here I have three forms with frmGoods as the main form and two popup forms(frmGoodsAdd, frmGoodsProfile)
frmGoods is the main form. This form contains a noun field as does the frmGoodsProfile. When the user types in a noun in the noun field I am trying to do a search on the noun field in the tblGoodsProfile. If the noun fields in both the frmGoods and tblGoodsProfile match then the popup frmGoodsAdd should allow the users to enter values (two fields appear but only a value field should be edited). If the noun fields do not match the user will get a popup to enter a noun name a attribute names related to the noun.
I have tried using the Dlookup function along with macros and filters and still have not found a solution. Please help. If you need additional information please let me know.
Signed Desperate.
Goods
GoodsAdd
GoodsProfile
The Goods table contains the required data including a primary key which is joined to the GoodsAdd table on a foriegn key. This creates a one to many join. Goods on the one side and GoodsAdd on the many side.
There are three forms based on three queries qryGoods, qryGoodsAdd, and qr7GoodsProfile. From here I have three forms with frmGoods as the main form and two popup forms(frmGoodsAdd, frmGoodsProfile)
frmGoods is the main form. This form contains a noun field as does the frmGoodsProfile. When the user types in a noun in the noun field I am trying to do a search on the noun field in the tblGoodsProfile. If the noun fields in both the frmGoods and tblGoodsProfile match then the popup frmGoodsAdd should allow the users to enter values (two fields appear but only a value field should be edited). If the noun fields do not match the user will get a popup to enter a noun name a attribute names related to the noun.
I have tried using the Dlookup function along with macros and filters and still have not found a solution. Please help. If you need additional information please let me know.
Signed Desperate.