Let me be the first to say this, since you are new here. We are happy to assist new people, as we were all new once ourselves. All that we require is that the new person show an attempt to look up the answers in the documentation and to learn as they go before posting questions here.
Do you have Remedy documentation available? If not, the .pdfs are available for download from BMC's support site. http://www.bmc.com/info_center_support/overview/0,3252,19097_4736144,00.html There is also an extensive wikipedia site for Remedy, maintained by one of the top contributors to this forum. Having said all that, to answer your question, forms (of any kind) in Remedy equate 1 = 1 to tables in the DB. If you have the ability to see the DB structure, look at the records in the "arschema" table, and you will see that table "T1" is Group, or whatever. You may push records to the join form directly if you wish - the data will automatically push down to the base forms, and will either create or update the appropriate records. But that doesn't sound like the best solution to what you want to do. It sounds like that what you want is to associate the customer record to the orders (1 to many). That is done by creating an interface to the order table on the customer form. Use a table field on the customer form to display the orders for that customer, and create buttons to add, modify, or remove the selected row from the table. Rick -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Chanan Berler Sent: Saturday, March 17, 2007 3:16 PM To: [email protected] Subject: some Remedy questions Hi All, I am new to Remedy so i will probably post many questions, and here some of them: 1) When openning a form, i was told it opens a table in the DB. What does happen when openning a join-form - does it also opens a temp table with both the tables fields? or does it just create a view for both of them. i will explain - i had a task (simple one in reqular DB - but hard for me to understand in Remedy) to create 2 tables: orders and customers. and then create a form which will create customer's order with all his details on it. So i create a join form with these 2 tables. Problem - when adding to the tables - should i push fields to the join form or to the tables themselfs (means order fields to order tables, and same to custoemrs with it's fields) thanks Chanan -- View this message in context: http://www.nabble.com/some-Remedy-questions-tf3420687.html#a9533957 Sent from the ARS (Action Request System) mailing list archive at Nabble.com. ____________________________________________________________________________ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
