I am trying to come up with the best way of doing the following: I have a form with two fields: one character field and the other drop-down. Each has a maximum of about 8 unique records.
What I want to do is create a cross reference file in that form of all possible combinations of those data values, and I want to populate it automatically from scratch. The trigger isn't all that important - I have some flexibility there. I cannot seed the data in the character field - it is read from the DB via a SQL call to a metatable, and each installation may have different data. I have thought about building a series of guides to read the data and create the data, or doing it directly in SQL. I have the SQL call to read the data for the character field already working in a menu that's attached to that field. The problem is that I can't figure out how to use the SQL to create new records via workflow, unless I also use a direct SQL call to write the data to the form. That's sounding like it might be a farily complex stored procedure that I have no experience in constructing. Anyone done something like this before? I thought it was going to be much easier than its looking like now, and I think I'm getting into analysis paralysis mode. Rick _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are"
