i am having trouble linking info from a particular cell from parent table to a unrelated form.
how can that be done.
any help would be greatly appreciated
i am having trouble linking info from a particular cell from parent table to a unrelated form.
how can that be done.
any help would be greatly appreciated
What do you mean by 'unrelated form'? The source data tables/queries do not have key relationship? Need to know more about your data structure and how forms are set up. Provide project for analysis.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
i have a table with my suppliers product names and prices in it.
i am now creating a form that requires a price from that particular table, from a cell in that table, to assist in a calculation.
in time i will be creating multiple forms, using that and or similar cells from that particular table.
as my suppliers change their prices i would rather change the price only once in the oiganal table than have to go thru andd change multiple forms manually
That doesn't clarify situation. Why multiple forms? How are you retrieving the price info and storing for each purchase record - are you saving ID of record from product table or the actual price? Do you want the price associated with that purchase to never be changed?
You need to resolve these questions and design data structure appropriately. Post for analysis.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.