Some outer join of the form with itself enbeded into a select statement will give you all the combinations.
Regards, Nicky Madjarov phone: 973-202-4278 Find out how to bust your AR System performance @ http://www.SpeedUpARS.com ----- Original Message ----- From: Rick Cook Newsgroups: public.remedy.arsystem.general To: [email protected] Sent: Thursday, April 16, 2009 11:57 AM Subject: Form population conundrum ** 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 _Platinum Sponsor: [email protected] ARSlist: "Where the Answers Are"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are"
