SpaghettiStraps
Programmer
mike presswood's book has a little section on how to keep to forms in sync but i don't know how to translate this into table frames.
i have two tables:
"constituents"
ImportID A20*
LastName A30
FirstName A15
Solicitor# A3
"projected income"
ImportID A20*
Expected Amt $
Reforecast Amount $
Actual Received $
what i want is the equivalent of a "live query" where a person can update the "projected income" table directly. the problem is -- without the last name, first name, and solicitor# fields from "constituents" the projected income table is useless. and it needs to be in table format (i.e. looking like a spreadsheet). i tried the data model route and when i link the two tables i can get all the fields in the table frame BUT the fields from "constituents" can't be filtered or sorted -- which is also necessary.
am i making any sense? so i thought if in the data model, rather than linking the two tables, i'd have them unlinked and "sync" them on the form. but that's where i'm stumped.
your help would be appreciated. thanks.
i have two tables:
"constituents"
ImportID A20*
LastName A30
FirstName A15
Solicitor# A3
"projected income"
ImportID A20*
Expected Amt $
Reforecast Amount $
Actual Received $
what i want is the equivalent of a "live query" where a person can update the "projected income" table directly. the problem is -- without the last name, first name, and solicitor# fields from "constituents" the projected income table is useless. and it needs to be in table format (i.e. looking like a spreadsheet). i tried the data model route and when i link the two tables i can get all the fields in the table frame BUT the fields from "constituents" can't be filtered or sorted -- which is also necessary.
am i making any sense? so i thought if in the data model, rather than linking the two tables, i'd have them unlinked and "sync" them on the form. but that's where i'm stumped.
your help would be appreciated. thanks.