A good friend (and database guru) helped me with my problem, and we
determined that it was a simple conceptual problem... and if I could
use the subforms I so dreaded and make them invisible, that would solve
my troubles. We worked up an example at home over the weekend, and got
it to work.
Now I'm attempting to replicate it at work. Basic structure: since the
boss wants a user interface like the worksheet, I have a Worksheet table
with a RecordID primary key that holds the following: BuyerContactID,
BuyerInterviewID, BrokerID, and a few other links to tables containing
the actual information for each record. BuyerContact, BuyerInterview,
etc. are subforms in the main form.
Now I'm getting an error message when I attempt to add something to my
subform... waiting to hear from the friend.
Thank you for the advice, though.
--
Posted via
http://dbforums.com